Overview

Dataset statistics

Number of variables37
Number of observations114073
Missing cells166253
Missing cells (%)3.9%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory32.2 MiB
Average record size in memory296.0 B

Variable types

Categorical24
Numeric13

Warnings

id_pedido has a high cardinality: 95128 distinct values High cardinality
id_consumidor has a high cardinality: 95128 distinct values High cardinality
horario_pedido has a high cardinality: 94624 distinct values High cardinality
pedido_aprovado has a high cardinality: 87124 distinct values High cardinality
pedido_com_entregador has a high cardinality: 78920 distinct values High cardinality
pedido_entregue has a high cardinality: 94340 distinct values High cardinality
data_estimada has a high cardinality: 444 distinct values High cardinality
produto_id has a high cardinality: 31625 distinct values High cardinality
vendedor_id has a high cardinality: 2914 distinct values High cardinality
data_limite_envio has a high cardinality: 90127 distinct values High cardinality
id_review has a high cardinality: 94947 distinct values High cardinality
titulo_review has a high cardinality: 4409 distinct values High cardinality
comentario_review has a high cardinality: 34589 distinct values High cardinality
data_criacao_review has a high cardinality: 627 distinct values High cardinality
data_resposta_review has a high cardinality: 94800 distinct values High cardinality
categoria_produto has a high cardinality: 73 distinct values High cardinality
id_unico_consumidor has a high cardinality: 92081 distinct values High cardinality
cidade_consumidor has a high cardinality: 4073 distinct values High cardinality
cidade_vendedor has a high cardinality: 588 distinct values High cardinality
titulo_review has 100406 (88.0%) missing values Missing
comentario_review has 65847 (57.7%) missing values Missing
id_pedido is uniformly distributed Uniform
id_consumidor is uniformly distributed Uniform
horario_pedido is uniformly distributed Uniform
pedido_aprovado is uniformly distributed Uniform
pedido_entregue is uniformly distributed Uniform
data_limite_envio is uniformly distributed Uniform
id_review is uniformly distributed Uniform
data_resposta_review is uniformly distributed Uniform
id_unico_consumidor is uniformly distributed Uniform

Reproduction

Analysis started2021-02-26 13:00:43.872584
Analysis finished2021-02-26 13:01:55.206795
Duration1 minute and 11.33 seconds
Software versionpandas-profiling v2.11.0
Download configurationconfig.yaml

Variables

id_pedido
Categorical

HIGH CARDINALITY
UNIFORM

Distinct95128
Distinct (%)83.4%
Missing0
Missing (%)0.0%
Memory size891.3 KiB
895ab968e7bb0d5659d16cd74cd1650c
 
63
fedcd9f7ccdc8cba3a18defedd1a5547
 
38
ccf804e764ed5650cd8759557269dc13
 
26
465c2e1bee4561cb39e0db8c5993aafc
 
24
a3725dfe487d359b5be08cac48b64ec5
 
24
Other values (95123)
113898 

Length

Max length32
Median length32
Mean length32
Min length32

Characters and Unicode

Total characters3650336
Distinct characters16
Distinct categories2 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique82632 ?
Unique (%)72.4%

Sample

1st rowe481f51cbdc54678b7cc49136f2d6af7
2nd rowe481f51cbdc54678b7cc49136f2d6af7
3rd rowe481f51cbdc54678b7cc49136f2d6af7
4th row128e10d95713541c87cd1a2e48201934
5th row0e7e841ddf8f8f2de2bad69267ecfbcf
ValueCountFrequency (%)
895ab968e7bb0d5659d16cd74cd1650c63
 
0.1%
fedcd9f7ccdc8cba3a18defedd1a554738
 
< 0.1%
ccf804e764ed5650cd8759557269dc1326
 
< 0.1%
465c2e1bee4561cb39e0db8c5993aafc24
 
< 0.1%
a3725dfe487d359b5be08cac48b64ec524
 
< 0.1%
68986e4324f6a21481df4e6e89abcf0124
 
< 0.1%
c6492b842ac190db807c15aff21a7dd624
 
< 0.1%
6d58638e32674bebee793a47ac4cbadc24
 
< 0.1%
285c2e15bebd4ac83635ccc563dc71f422
 
< 0.1%
5a3b1c29a49756e75f1ef513383c0c1222
 
< 0.1%
Other values (95118)113782
99.7%
Histogram of lengths of the category
ValueCountFrequency (%)
895ab968e7bb0d5659d16cd74cd1650c63
 
0.1%
fedcd9f7ccdc8cba3a18defedd1a554738
 
< 0.1%
ccf804e764ed5650cd8759557269dc1326
 
< 0.1%
465c2e1bee4561cb39e0db8c5993aafc24
 
< 0.1%
a3725dfe487d359b5be08cac48b64ec524
 
< 0.1%
68986e4324f6a21481df4e6e89abcf0124
 
< 0.1%
c6492b842ac190db807c15aff21a7dd624
 
< 0.1%
6d58638e32674bebee793a47ac4cbadc24
 
< 0.1%
285c2e15bebd4ac83635ccc563dc71f422
 
< 0.1%
5a3b1c29a49756e75f1ef513383c0c1222
 
< 0.1%
Other values (95118)113782
99.7%

Most occurring characters

ValueCountFrequency (%)
b229322
 
6.3%
4229296
 
6.3%
6229120
 
6.3%
e228858
 
6.3%
3228453
 
6.3%
c228324
 
6.3%
7228282
 
6.3%
1228182
 
6.3%
a228179
 
6.3%
8228133
 
6.2%
Other values (6)1364187
37.4%

Most occurring categories

ValueCountFrequency (%)
Decimal Number2280671
62.5%
Lowercase Letter1369665
37.5%

Most frequent character per category

ValueCountFrequency (%)
4229296
10.1%
6229120
10.0%
3228453
10.0%
7228282
10.0%
1228182
10.0%
8228133
10.0%
2227750
10.0%
9227476
10.0%
0227102
10.0%
5226877
9.9%
ValueCountFrequency (%)
b229322
16.7%
e228858
16.7%
c228324
16.7%
a228179
16.7%
f227940
16.6%
d227042
16.6%

Most occurring scripts

ValueCountFrequency (%)
Common2280671
62.5%
Latin1369665
37.5%

Most frequent character per script

ValueCountFrequency (%)
4229296
10.1%
6229120
10.0%
3228453
10.0%
7228282
10.0%
1228182
10.0%
8228133
10.0%
2227750
10.0%
9227476
10.0%
0227102
10.0%
5226877
9.9%
ValueCountFrequency (%)
b229322
16.7%
e228858
16.7%
c228324
16.7%
a228179
16.7%
f227940
16.6%
d227042
16.6%

Most occurring blocks

ValueCountFrequency (%)
ASCII3650336
100.0%

Most frequent character per block

ValueCountFrequency (%)
b229322
 
6.3%
4229296
 
6.3%
6229120
 
6.3%
e228858
 
6.3%
3228453
 
6.3%
c228324
 
6.3%
7228282
 
6.3%
1228182
 
6.3%
a228179
 
6.3%
8228133
 
6.2%
Other values (6)1364187
37.4%

id_consumidor
Categorical

HIGH CARDINALITY
UNIFORM

Distinct95128
Distinct (%)83.4%
Missing0
Missing (%)0.0%
Memory size891.3 KiB
270c23a11d024a44c896d1894b261a83
 
63
13aa59158da63ba0e93ec6ac2c07aacb
 
38
92cd3ec6e2d643d4ebd0e3d6238f69e2
 
26
63b964e79dee32a3587651701a2b8dbf
 
24
86cc80fef09f7f39df4b0dbce48e81cb
 
24
Other values (95123)
113898 

Length

Max length32
Median length32
Mean length32
Min length32

Characters and Unicode

Total characters3650336
Distinct characters16
Distinct categories2 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique82632 ?
Unique (%)72.4%

Sample

1st row9ef432eb6251297304e76186b10a928d
2nd row9ef432eb6251297304e76186b10a928d
3rd row9ef432eb6251297304e76186b10a928d
4th rowa20e8105f23924cd00833fd87daa0831
5th row26c7ac168e1433912a51b924fbd34d34
ValueCountFrequency (%)
270c23a11d024a44c896d1894b261a8363
 
0.1%
13aa59158da63ba0e93ec6ac2c07aacb38
 
< 0.1%
92cd3ec6e2d643d4ebd0e3d6238f69e226
 
< 0.1%
63b964e79dee32a3587651701a2b8dbf24
 
< 0.1%
86cc80fef09f7f39df4b0dbce48e81cb24
 
< 0.1%
2ba91e12e5e4c9f56b82b86d9031d32924
 
< 0.1%
d22f25a9fadfb1abbc2e29395b1239f424
 
< 0.1%
6ee2f17e3b6c33d6a9557f280edd292524
 
< 0.1%
b246eeed30b362c09d867b9e598bee5122
 
< 0.1%
be1c4e52bb71e0c54b11a26b8e8d59f222
 
< 0.1%
Other values (95118)113782
99.7%
Histogram of lengths of the category
ValueCountFrequency (%)
270c23a11d024a44c896d1894b261a8363
 
0.1%
13aa59158da63ba0e93ec6ac2c07aacb38
 
< 0.1%
92cd3ec6e2d643d4ebd0e3d6238f69e226
 
< 0.1%
63b964e79dee32a3587651701a2b8dbf24
 
< 0.1%
86cc80fef09f7f39df4b0dbce48e81cb24
 
< 0.1%
2ba91e12e5e4c9f56b82b86d9031d32924
 
< 0.1%
d22f25a9fadfb1abbc2e29395b1239f424
 
< 0.1%
6ee2f17e3b6c33d6a9557f280edd292524
 
< 0.1%
b246eeed30b362c09d867b9e598bee5122
 
< 0.1%
be1c4e52bb71e0c54b11a26b8e8d59f222
 
< 0.1%
Other values (95118)113782
99.7%

Most occurring characters

ValueCountFrequency (%)
2228874
 
6.3%
f228638
 
6.3%
5228597
 
6.3%
c228587
 
6.3%
6228576
 
6.3%
1228330
 
6.3%
d228207
 
6.3%
8228178
 
6.3%
a228173
 
6.3%
e228108
 
6.2%
Other values (6)1366068
37.4%

Most occurring categories

ValueCountFrequency (%)
Decimal Number2280573
62.5%
Lowercase Letter1369763
37.5%

Most frequent character per category

ValueCountFrequency (%)
2228874
10.0%
5228597
10.0%
6228576
10.0%
1228330
10.0%
8228178
10.0%
7228055
10.0%
9228023
10.0%
3227945
10.0%
4227063
10.0%
0226932
10.0%
ValueCountFrequency (%)
f228638
16.7%
c228587
16.7%
d228207
16.7%
a228173
16.7%
e228108
16.7%
b228050
16.6%

Most occurring scripts

ValueCountFrequency (%)
Common2280573
62.5%
Latin1369763
37.5%

Most frequent character per script

ValueCountFrequency (%)
2228874
10.0%
5228597
10.0%
6228576
10.0%
1228330
10.0%
8228178
10.0%
7228055
10.0%
9228023
10.0%
3227945
10.0%
4227063
10.0%
0226932
10.0%
ValueCountFrequency (%)
f228638
16.7%
c228587
16.7%
d228207
16.7%
a228173
16.7%
e228108
16.7%
b228050
16.6%

Most occurring blocks

ValueCountFrequency (%)
ASCII3650336
100.0%

Most frequent character per block

ValueCountFrequency (%)
2228874
 
6.3%
f228638
 
6.3%
5228597
 
6.3%
c228587
 
6.3%
6228576
 
6.3%
1228330
 
6.3%
d228207
 
6.3%
8228178
 
6.3%
a228173
 
6.3%
e228108
 
6.2%
Other values (6)1366068
37.4%

status_da_ordem
Categorical

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size891.3 KiB
delivered
114066 
canceled
 
7

Length

Max length9
Median length9
Mean length8.999938636
Min length8

Characters and Unicode

Total characters1026650
Distinct characters9
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowdelivered
2nd rowdelivered
3rd rowdelivered
4th rowdelivered
5th rowdelivered
ValueCountFrequency (%)
delivered114066
> 99.9%
canceled7
 
< 0.1%
Histogram of lengths of the category
ValueCountFrequency (%)
delivered114066
> 99.9%
canceled7
 
< 0.1%

Most occurring characters

ValueCountFrequency (%)
e342212
33.3%
d228139
22.2%
l114073
 
11.1%
i114066
 
11.1%
v114066
 
11.1%
r114066
 
11.1%
c14
 
< 0.1%
a7
 
< 0.1%
n7
 
< 0.1%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter1026650
100.0%

Most frequent character per category

ValueCountFrequency (%)
e342212
33.3%
d228139
22.2%
l114073
 
11.1%
i114066
 
11.1%
v114066
 
11.1%
r114066
 
11.1%
c14
 
< 0.1%
a7
 
< 0.1%
n7
 
< 0.1%

Most occurring scripts

ValueCountFrequency (%)
Latin1026650
100.0%

Most frequent character per script

ValueCountFrequency (%)
e342212
33.3%
d228139
22.2%
l114073
 
11.1%
i114066
 
11.1%
v114066
 
11.1%
r114066
 
11.1%
c14
 
< 0.1%
a7
 
< 0.1%
n7
 
< 0.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII1026650
100.0%

Most frequent character per block

ValueCountFrequency (%)
e342212
33.3%
d228139
22.2%
l114073
 
11.1%
i114066
 
11.1%
v114066
 
11.1%
r114066
 
11.1%
c14
 
< 0.1%
a7
 
< 0.1%
n7
 
< 0.1%

horario_pedido
Categorical

HIGH CARDINALITY
UNIFORM

Distinct94624
Distinct (%)83.0%
Missing0
Missing (%)0.0%
Memory size891.3 KiB
2017-08-08 20:26:31
 
63
2017-09-23 14:56:45
 
38
2017-06-07 12:05:10
 
26
2018-02-14 16:34:27
 
24
2017-11-25 13:54:39
 
24
Other values (94619)
113898 

Length

Max length19
Median length19
Mean length19
Min length19

Characters and Unicode

Total characters2167387
Distinct characters13
Distinct categories4 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique81889 ?
Unique (%)71.8%

Sample

1st row2017-10-02 10:56:33
2nd row2017-10-02 10:56:33
3rd row2017-10-02 10:56:33
4th row2017-08-15 18:29:31
5th row2017-08-02 18:24:47
ValueCountFrequency (%)
2017-08-08 20:26:3163
 
0.1%
2017-09-23 14:56:4538
 
< 0.1%
2017-06-07 12:05:1026
 
< 0.1%
2018-02-14 16:34:2724
 
< 0.1%
2017-11-25 13:54:3924
 
< 0.1%
2017-07-07 14:55:4324
 
< 0.1%
2018-05-12 12:28:5824
 
< 0.1%
2017-03-09 23:39:2624
 
< 0.1%
2017-10-17 13:06:2922
 
< 0.1%
2017-12-08 12:00:0422
 
< 0.1%
Other values (94614)113782
99.7%
Histogram of lengths of the category
ValueCountFrequency (%)
2017-11-241389
 
0.6%
2017-11-25620
 
0.3%
2017-11-27493
 
0.2%
2017-11-26470
 
0.2%
2017-11-28438
 
0.2%
2018-05-15435
 
0.2%
2018-08-06434
 
0.2%
2018-08-07422
 
0.2%
2018-05-07416
 
0.2%
2018-05-16414
 
0.2%
Other values (50475)222615
97.6%

Most occurring characters

ValueCountFrequency (%)
1352634
16.3%
0351078
16.2%
2278326
12.8%
-228146
10.5%
:228146
10.5%
8118856
 
5.5%
114073
 
5.3%
7105751
 
4.9%
3100713
 
4.6%
592165
 
4.3%
Other values (3)197499
9.1%

Most occurring categories

ValueCountFrequency (%)
Decimal Number1597022
73.7%
Dash Punctuation228146
 
10.5%
Other Punctuation228146
 
10.5%
Space Separator114073
 
5.3%

Most frequent character per category

ValueCountFrequency (%)
1352634
22.1%
0351078
22.0%
2278326
17.4%
8118856
 
7.4%
7105751
 
6.6%
3100713
 
6.3%
592165
 
5.8%
492068
 
5.8%
654373
 
3.4%
951058
 
3.2%
ValueCountFrequency (%)
-228146
100.0%
ValueCountFrequency (%)
114073
100.0%
ValueCountFrequency (%)
:228146
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common2167387
100.0%

Most frequent character per script

ValueCountFrequency (%)
1352634
16.3%
0351078
16.2%
2278326
12.8%
-228146
10.5%
:228146
10.5%
8118856
 
5.5%
114073
 
5.3%
7105751
 
4.9%
3100713
 
4.6%
592165
 
4.3%
Other values (3)197499
9.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII2167387
100.0%

Most frequent character per block

ValueCountFrequency (%)
1352634
16.3%
0351078
16.2%
2278326
12.8%
-228146
10.5%
:228146
10.5%
8118856
 
5.5%
114073
 
5.3%
7105751
 
4.9%
3100713
 
4.6%
592165
 
4.3%
Other values (3)197499
9.1%

pedido_aprovado
Categorical

HIGH CARDINALITY
UNIFORM

Distinct87124
Distinct (%)76.4%
Missing0
Missing (%)0.0%
Memory size891.3 KiB
2017-08-08 20:43:31
 
63
2017-09-25 17:44:41
 
38
2017-06-09 16:15:08
 
26
2017-11-25 14:16:34
 
24
2018-02-21 12:28:15
 
24
Other values (87119)
113898 

Length

Max length19
Median length19
Mean length19
Min length19

Characters and Unicode

Total characters2167387
Distinct characters13
Distinct categories4 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique69811 ?
Unique (%)61.2%

Sample

1st row2017-10-02 11:07:15
2nd row2017-10-02 11:07:15
3rd row2017-10-02 11:07:15
4th row2017-08-15 20:05:16
5th row2017-08-02 18:43:15
ValueCountFrequency (%)
2017-08-08 20:43:3163
 
0.1%
2017-09-25 17:44:4138
 
< 0.1%
2017-06-09 16:15:0826
 
< 0.1%
2017-11-25 14:16:3424
 
< 0.1%
2018-02-21 12:28:1524
 
< 0.1%
2017-07-07 15:10:1724
 
< 0.1%
2017-03-09 23:39:2624
 
< 0.1%
2018-05-12 15:41:5824
 
< 0.1%
2018-02-24 03:20:2723
 
< 0.1%
2017-10-18 13:06:2122
 
< 0.1%
Other values (87114)113781
99.7%
Histogram of lengths of the category
ValueCountFrequency (%)
2018-04-241144
 
0.5%
2017-11-24964
 
0.4%
2017-11-25909
 
0.4%
2018-07-05812
 
0.4%
2017-11-28587
 
0.3%
2018-08-07487
 
0.2%
2018-05-08484
 
0.2%
2018-08-20483
 
0.2%
2018-05-01477
 
0.2%
2018-05-15467
 
0.2%
Other values (41481)221332
97.0%

Most occurring characters

ValueCountFrequency (%)
0365589
16.9%
1350764
16.2%
2277141
12.8%
-228146
10.5%
:228146
10.5%
114073
 
5.3%
8113012
 
5.2%
5110005
 
5.1%
3106908
 
4.9%
7100945
 
4.7%
Other values (3)172658
8.0%

Most occurring categories

ValueCountFrequency (%)
Decimal Number1597022
73.7%
Dash Punctuation228146
 
10.5%
Other Punctuation228146
 
10.5%
Space Separator114073
 
5.3%

Most frequent character per category

ValueCountFrequency (%)
0365589
22.9%
1350764
22.0%
2277141
17.4%
8113012
 
7.1%
5110005
 
6.9%
3106908
 
6.7%
7100945
 
6.3%
479109
 
5.0%
649315
 
3.1%
944234
 
2.8%
ValueCountFrequency (%)
-228146
100.0%
ValueCountFrequency (%)
114073
100.0%
ValueCountFrequency (%)
:228146
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common2167387
100.0%

Most frequent character per script

ValueCountFrequency (%)
0365589
16.9%
1350764
16.2%
2277141
12.8%
-228146
10.5%
:228146
10.5%
114073
 
5.3%
8113012
 
5.2%
5110005
 
5.1%
3106908
 
4.9%
7100945
 
4.7%
Other values (3)172658
8.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII2167387
100.0%

Most frequent character per block

ValueCountFrequency (%)
0365589
16.9%
1350764
16.2%
2277141
12.8%
-228146
10.5%
:228146
10.5%
114073
 
5.3%
8113012
 
5.2%
5110005
 
5.1%
3106908
 
4.9%
7100945
 
4.7%
Other values (3)172658
8.0%

pedido_com_entregador
Categorical

HIGH CARDINALITY

Distinct78920
Distinct (%)69.2%
Missing0
Missing (%)0.0%
Memory size891.3 KiB
2017-08-10 11:58:14
 
63
2018-05-09 15:48:00
 
48
2017-10-02 23:47:54
 
38
2018-05-10 18:29:00
 
36
2018-05-14 14:25:00
 
32
Other values (78915)
113856 

Length

Max length19
Median length19
Mean length19
Min length19

Characters and Unicode

Total characters2167387
Distinct characters13
Distinct categories4 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique59772 ?
Unique (%)52.4%

Sample

1st row2017-10-04 19:55:00
2nd row2017-10-04 19:55:00
3rd row2017-10-04 19:55:00
4th row2017-08-17 15:28:33
5th row2017-08-04 17:35:43
ValueCountFrequency (%)
2017-08-10 11:58:1463
 
0.1%
2018-05-09 15:48:0048
 
< 0.1%
2017-10-02 23:47:5438
 
< 0.1%
2018-05-10 18:29:0036
 
< 0.1%
2018-05-14 14:25:0032
 
< 0.1%
2018-05-04 15:46:0029
 
< 0.1%
2018-08-08 15:01:0027
 
< 0.1%
2017-06-16 15:50:2826
 
< 0.1%
2017-03-15 11:16:3324
 
< 0.1%
2018-06-13 14:13:0024
 
< 0.1%
Other values (78910)113726
99.7%
Histogram of lengths of the category
ValueCountFrequency (%)
2017-11-28909
 
0.4%
2017-11-27791
 
0.3%
2017-11-29693
 
0.3%
2018-02-27613
 
0.3%
2018-03-27610
 
0.3%
2018-08-06588
 
0.3%
2017-11-30569
 
0.2%
2018-05-14561
 
0.2%
2018-08-13543
 
0.2%
2018-05-03529
 
0.2%
Other values (36935)221740
97.2%

Most occurring characters

ValueCountFrequency (%)
0395677
18.3%
1337889
15.6%
2268474
12.4%
-228146
10.5%
:228146
10.5%
8120610
 
5.6%
114073
 
5.3%
7103767
 
4.8%
395838
 
4.4%
489488
 
4.1%
Other values (3)185279
8.5%

Most occurring categories

ValueCountFrequency (%)
Decimal Number1597022
73.7%
Dash Punctuation228146
 
10.5%
Other Punctuation228146
 
10.5%
Space Separator114073
 
5.3%

Most frequent character per category

ValueCountFrequency (%)
0395677
24.8%
1337889
21.2%
2268474
16.8%
8120610
 
7.6%
7103767
 
6.5%
395838
 
6.0%
489488
 
5.6%
587569
 
5.5%
650224
 
3.1%
947486
 
3.0%
ValueCountFrequency (%)
-228146
100.0%
ValueCountFrequency (%)
114073
100.0%
ValueCountFrequency (%)
:228146
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common2167387
100.0%

Most frequent character per script

ValueCountFrequency (%)
0395677
18.3%
1337889
15.6%
2268474
12.4%
-228146
10.5%
:228146
10.5%
8120610
 
5.6%
114073
 
5.3%
7103767
 
4.8%
395838
 
4.4%
489488
 
4.1%
Other values (3)185279
8.5%

Most occurring blocks

ValueCountFrequency (%)
ASCII2167387
100.0%

Most frequent character per block

ValueCountFrequency (%)
0395677
18.3%
1337889
15.6%
2268474
12.4%
-228146
10.5%
:228146
10.5%
8120610
 
5.6%
114073
 
5.3%
7103767
 
4.8%
395838
 
4.4%
489488
 
4.1%
Other values (3)185279
8.5%

pedido_entregue
Categorical

HIGH CARDINALITY
UNIFORM

Distinct94340
Distinct (%)82.7%
Missing0
Missing (%)0.0%
Memory size891.3 KiB
2017-08-14 12:46:18
 
63
2017-10-18 22:35:50
 
38
2017-06-22 16:04:46
 
26
2018-02-28 20:09:19
 
24
2017-11-30 14:59:18
 
24
Other values (94335)
113898 

Length

Max length19
Median length19
Mean length19
Min length19

Characters and Unicode

Total characters2167387
Distinct characters13
Distinct categories4 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique81262 ?
Unique (%)71.2%

Sample

1st row2017-10-10 21:25:13
2nd row2017-10-10 21:25:13
3rd row2017-10-10 21:25:13
4th row2017-08-18 14:44:43
5th row2017-08-07 18:30:01
ValueCountFrequency (%)
2017-08-14 12:46:1863
 
0.1%
2017-10-18 22:35:5038
 
< 0.1%
2017-06-22 16:04:4626
 
< 0.1%
2018-02-28 20:09:1924
 
< 0.1%
2017-11-30 14:59:1824
 
< 0.1%
2017-03-21 13:32:4524
 
< 0.1%
2017-07-27 20:52:1524
 
< 0.1%
2018-06-01 15:18:4524
 
< 0.1%
2017-10-22 14:43:5422
 
< 0.1%
2017-12-21 16:33:1022
 
< 0.1%
Other values (94330)113782
99.7%
Histogram of lengths of the category
ValueCountFrequency (%)
2018-05-14527
 
0.2%
2018-05-21526
 
0.2%
2018-08-13505
 
0.2%
2018-05-18503
 
0.2%
2018-08-27501
 
0.2%
2018-05-03499
 
0.2%
2018-04-11487
 
0.2%
2017-12-11482
 
0.2%
2018-08-23479
 
0.2%
2018-04-30479
 
0.2%
Other values (41437)223158
97.8%

Most occurring characters

ValueCountFrequency (%)
1335148
15.5%
0331892
15.3%
2286993
13.2%
-228146
10.5%
:228146
10.5%
8133871
 
6.2%
114073
 
5.3%
7105557
 
4.9%
3105443
 
4.9%
498848
 
4.6%
Other values (3)199270
9.2%

Most occurring categories

ValueCountFrequency (%)
Decimal Number1597022
73.7%
Dash Punctuation228146
 
10.5%
Other Punctuation228146
 
10.5%
Space Separator114073
 
5.3%

Most frequent character per category

ValueCountFrequency (%)
1335148
21.0%
0331892
20.8%
2286993
18.0%
8133871
 
8.4%
7105557
 
6.6%
3105443
 
6.6%
498848
 
6.2%
592409
 
5.8%
657714
 
3.6%
949147
 
3.1%
ValueCountFrequency (%)
-228146
100.0%
ValueCountFrequency (%)
114073
100.0%
ValueCountFrequency (%)
:228146
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common2167387
100.0%

Most frequent character per script

ValueCountFrequency (%)
1335148
15.5%
0331892
15.3%
2286993
13.2%
-228146
10.5%
:228146
10.5%
8133871
 
6.2%
114073
 
5.3%
7105557
 
4.9%
3105443
 
4.9%
498848
 
4.6%
Other values (3)199270
9.2%

Most occurring blocks

ValueCountFrequency (%)
ASCII2167387
100.0%

Most frequent character per block

ValueCountFrequency (%)
1335148
15.5%
0331892
15.3%
2286993
13.2%
-228146
10.5%
:228146
10.5%
8133871
 
6.2%
114073
 
5.3%
7105557
 
4.9%
3105443
 
4.9%
498848
 
4.6%
Other values (3)199270
9.2%

data_estimada
Categorical

HIGH CARDINALITY

Distinct444
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size891.3 KiB
2017-12-20 00:00:00
 
644
2018-03-12 00:00:00
 
597
2018-05-29 00:00:00
 
591
2018-07-16 00:00:00
 
584
2018-03-13 00:00:00
 
582
Other values (439)
111075 

Length

Max length19
Median length19
Mean length19
Min length19

Characters and Unicode

Total characters2167387
Distinct characters13
Distinct categories4 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique15 ?
Unique (%)< 0.1%

Sample

1st row2017-10-18 00:00:00
2nd row2017-10-18 00:00:00
3rd row2017-10-18 00:00:00
4th row2017-08-28 00:00:00
5th row2017-08-15 00:00:00
ValueCountFrequency (%)
2017-12-20 00:00:00644
 
0.6%
2018-03-12 00:00:00597
 
0.5%
2018-05-29 00:00:00591
 
0.5%
2018-07-16 00:00:00584
 
0.5%
2018-03-13 00:00:00582
 
0.5%
2018-07-05 00:00:00578
 
0.5%
2018-05-30 00:00:00578
 
0.5%
2018-02-14 00:00:00573
 
0.5%
2018-05-28 00:00:00570
 
0.5%
2018-07-18 00:00:00569
 
0.5%
Other values (434)108207
94.9%
Histogram of lengths of the category
ValueCountFrequency (%)
00:00:00114073
50.0%
2017-12-20644
 
0.3%
2018-03-12597
 
0.3%
2018-05-29591
 
0.3%
2018-07-16584
 
0.3%
2018-03-13582
 
0.3%
2018-05-30578
 
0.3%
2018-07-05578
 
0.3%
2018-02-14573
 
0.3%
2018-05-28570
 
0.2%
Other values (435)108776
47.7%

Most occurring characters

ValueCountFrequency (%)
0943524
43.5%
-228146
 
10.5%
:228146
 
10.5%
1195288
 
9.0%
2177800
 
8.2%
114073
 
5.3%
894804
 
4.4%
769340
 
3.2%
330465
 
1.4%
523446
 
1.1%
Other values (3)62355
 
2.9%

Most occurring categories

ValueCountFrequency (%)
Decimal Number1597022
73.7%
Dash Punctuation228146
 
10.5%
Other Punctuation228146
 
10.5%
Space Separator114073
 
5.3%

Most frequent character per category

ValueCountFrequency (%)
0943524
59.1%
1195288
 
12.2%
2177800
 
11.1%
894804
 
5.9%
769340
 
4.3%
330465
 
1.9%
523446
 
1.5%
622197
 
1.4%
421259
 
1.3%
918899
 
1.2%
ValueCountFrequency (%)
-228146
100.0%
ValueCountFrequency (%)
114073
100.0%
ValueCountFrequency (%)
:228146
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common2167387
100.0%

Most frequent character per script

ValueCountFrequency (%)
0943524
43.5%
-228146
 
10.5%
:228146
 
10.5%
1195288
 
9.0%
2177800
 
8.2%
114073
 
5.3%
894804
 
4.4%
769340
 
3.2%
330465
 
1.4%
523446
 
1.1%
Other values (3)62355
 
2.9%

Most occurring blocks

ValueCountFrequency (%)
ASCII2167387
100.0%

Most frequent character per block

ValueCountFrequency (%)
0943524
43.5%
-228146
 
10.5%
:228146
 
10.5%
1195288
 
9.0%
2177800
 
8.2%
114073
 
5.3%
894804
 
4.4%
769340
 
3.2%
330465
 
1.4%
523446
 
1.1%
Other values (3)62355
 
2.9%

item_id
Real number (ℝ≥0)

Distinct21
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.197505106
Minimum1
Maximum21
Zeros0
Zeros (%)0.0%
Memory size891.3 KiB

Quantile statistics

Minimum1
5-th percentile1
Q11
median1
Q31
95-th percentile2
Maximum21
Range20
Interquartile range (IQR)0

Descriptive statistics

Standard deviation0.7031296814
Coefficient of variation (CV)0.5871621571
Kurtosis104.4504502
Mean1.197505106
Median Absolute Deviation (MAD)0
Skewness7.605133406
Sum136603
Variance0.4943913489
MonotocityNot monotonic
Histogram with fixed size bins (bins=21)
ValueCountFrequency (%)
199866
87.5%
210006
 
8.8%
32321
 
2.0%
4957
 
0.8%
5448
 
0.4%
6256
 
0.2%
761
 
0.1%
836
 
< 0.1%
929
 
< 0.1%
1026
 
< 0.1%
Other values (11)67
 
0.1%
ValueCountFrequency (%)
199866
87.5%
210006
 
8.8%
32321
 
2.0%
4957
 
0.8%
5448
 
0.4%
ValueCountFrequency (%)
211
 
< 0.1%
203
< 0.1%
193
< 0.1%
183
< 0.1%
173
< 0.1%

produto_id
Categorical

HIGH CARDINALITY

Distinct31625
Distinct (%)27.7%
Missing0
Missing (%)0.0%
Memory size891.3 KiB
aca2eb7d00ea1a7b8ebd4e68314663af
 
529
99a4788cb24856965c36a24e339b6058
 
516
422879e10f46682990de24d770e7f83d
 
508
389d119b48cf3043d311335e499d9c6b
 
403
368c6c730842d78016ad823897a372db
 
398
Other values (31620)
111719 

Length

Max length32
Median length32
Mean length32
Min length32

Characters and Unicode

Total characters3650336
Distinct characters16
Distinct categories2 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique16621 ?
Unique (%)14.6%

Sample

1st row87285b34884572647811a353c7ac498a
2nd row87285b34884572647811a353c7ac498a
3rd row87285b34884572647811a353c7ac498a
4th row87285b34884572647811a353c7ac498a
5th row87285b34884572647811a353c7ac498a
ValueCountFrequency (%)
aca2eb7d00ea1a7b8ebd4e68314663af529
 
0.5%
99a4788cb24856965c36a24e339b6058516
 
0.5%
422879e10f46682990de24d770e7f83d508
 
0.4%
389d119b48cf3043d311335e499d9c6b403
 
0.4%
368c6c730842d78016ad823897a372db398
 
0.3%
53759a2ecddad2bb87a079a1f1519f73391
 
0.3%
d1c427060a0f73f6b889a5c7c61f2ac4346
 
0.3%
53b36df67ebb7c41585e8d54d6772e08325
 
0.3%
154e7e31ebfa092203795c972e5804a6287
 
0.3%
3dd2a17168ec895c781a9191c1e95ad7276
 
0.2%
Other values (31615)110094
96.5%
Histogram of lengths of the category
ValueCountFrequency (%)
aca2eb7d00ea1a7b8ebd4e68314663af529
 
0.5%
99a4788cb24856965c36a24e339b6058516
 
0.5%
422879e10f46682990de24d770e7f83d508
 
0.4%
389d119b48cf3043d311335e499d9c6b403
 
0.4%
368c6c730842d78016ad823897a372db398
 
0.3%
53759a2ecddad2bb87a079a1f1519f73391
 
0.3%
d1c427060a0f73f6b889a5c7c61f2ac4346
 
0.3%
53b36df67ebb7c41585e8d54d6772e08325
 
0.3%
154e7e31ebfa092203795c972e5804a6287
 
0.3%
3dd2a17168ec895c781a9191c1e95ad7276
 
0.2%
Other values (31615)110094
96.5%

Most occurring characters

ValueCountFrequency (%)
3234822
 
6.4%
9232956
 
6.4%
e230534
 
6.3%
7230035
 
6.3%
8229497
 
6.3%
4228276
 
6.3%
2227974
 
6.2%
0227939
 
6.2%
c227915
 
6.2%
a227906
 
6.2%
Other values (6)1352482
37.1%

Most occurring categories

ValueCountFrequency (%)
Decimal Number2291579
62.8%
Lowercase Letter1358757
37.2%

Most frequent character per category

ValueCountFrequency (%)
3234822
10.2%
9232956
10.2%
7230035
10.0%
8229497
10.0%
4228276
10.0%
2227974
9.9%
0227939
9.9%
6227809
9.9%
5226665
9.9%
1225606
9.8%
ValueCountFrequency (%)
e230534
17.0%
c227915
16.8%
a227906
16.8%
b226623
16.7%
d224316
16.5%
f221463
16.3%

Most occurring scripts

ValueCountFrequency (%)
Common2291579
62.8%
Latin1358757
37.2%

Most frequent character per script

ValueCountFrequency (%)
3234822
10.2%
9232956
10.2%
7230035
10.0%
8229497
10.0%
4228276
10.0%
2227974
9.9%
0227939
9.9%
6227809
9.9%
5226665
9.9%
1225606
9.8%
ValueCountFrequency (%)
e230534
17.0%
c227915
16.8%
a227906
16.8%
b226623
16.7%
d224316
16.5%
f221463
16.3%

Most occurring blocks

ValueCountFrequency (%)
ASCII3650336
100.0%

Most frequent character per block

ValueCountFrequency (%)
3234822
 
6.4%
9232956
 
6.4%
e230534
 
6.3%
7230035
 
6.3%
8229497
 
6.3%
4228276
 
6.3%
2227974
 
6.2%
0227939
 
6.2%
c227915
 
6.2%
a227906
 
6.2%
Other values (6)1352482
37.1%

vendedor_id
Categorical

HIGH CARDINALITY

Distinct2914
Distinct (%)2.6%
Missing0
Missing (%)0.0%
Memory size891.3 KiB
4a3ca9315b744ce9f8e9374361493884
 
2116
6560211a19b47992c3666cc44a7e94c0
 
2093
1f50f920176fa81dab994f9023523100
 
2011
cc419e0650a3c5ba77189a1882b7556a
 
1832
da8622b14eb17ae2831f4ac5b9dab84a
 
1656
Other values (2909)
104365 

Length

Max length32
Median length32
Mean length32
Min length32

Characters and Unicode

Total characters3650336
Distinct characters16
Distinct categories2 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique466 ?
Unique (%)0.4%

Sample

1st row3504c0cb71d7fa48d967e0e4c94d59d9
2nd row3504c0cb71d7fa48d967e0e4c94d59d9
3rd row3504c0cb71d7fa48d967e0e4c94d59d9
4th row3504c0cb71d7fa48d967e0e4c94d59d9
5th row3504c0cb71d7fa48d967e0e4c94d59d9
ValueCountFrequency (%)
4a3ca9315b744ce9f8e93743614938842116
 
1.9%
6560211a19b47992c3666cc44a7e94c02093
 
1.8%
1f50f920176fa81dab994f90235231002011
 
1.8%
cc419e0650a3c5ba77189a1882b7556a1832
 
1.6%
da8622b14eb17ae2831f4ac5b9dab84a1656
 
1.5%
955fee9216a65b617aa5c0531780ce601503
 
1.3%
1025f0e2d44d7041d6cf58b6550e0bfa1468
 
1.3%
7c67e1448b00f6e969d365cea6b010ab1454
 
1.3%
7a67c85e85bb2ce8582c35f2203ad7361226
 
1.1%
ea8482cd71df3c1969d7b9473ff13abc1224
 
1.1%
Other values (2904)97490
85.5%
Histogram of lengths of the category
ValueCountFrequency (%)
4a3ca9315b744ce9f8e93743614938842116
 
1.9%
6560211a19b47992c3666cc44a7e94c02093
 
1.8%
1f50f920176fa81dab994f90235231002011
 
1.8%
cc419e0650a3c5ba77189a1882b7556a1832
 
1.6%
da8622b14eb17ae2831f4ac5b9dab84a1656
 
1.5%
955fee9216a65b617aa5c0531780ce601503
 
1.3%
1025f0e2d44d7041d6cf58b6550e0bfa1468
 
1.3%
7c67e1448b00f6e969d365cea6b010ab1454
 
1.3%
7a67c85e85bb2ce8582c35f2203ad7361226
 
1.1%
ea8482cd71df3c1969d7b9473ff13abc1224
 
1.1%
Other values (2904)97490
85.5%

Most occurring characters

ValueCountFrequency (%)
1248750
 
6.8%
c240681
 
6.6%
4239821
 
6.6%
6234868
 
6.4%
0234519
 
6.4%
a233687
 
6.4%
b232658
 
6.4%
3232411
 
6.4%
9225692
 
6.2%
2224476
 
6.1%
Other values (6)1302773
35.7%

Most occurring categories

ValueCountFrequency (%)
Decimal Number2308365
63.2%
Lowercase Letter1341971
36.8%

Most frequent character per category

ValueCountFrequency (%)
1248750
10.8%
4239821
10.4%
6234868
10.2%
0234519
10.2%
3232411
10.1%
9225692
9.8%
2224476
9.7%
8223146
9.7%
5222860
9.7%
7221822
9.6%
ValueCountFrequency (%)
c240681
17.9%
a233687
17.4%
b232658
17.3%
e213586
15.9%
f211925
15.8%
d209434
15.6%

Most occurring scripts

ValueCountFrequency (%)
Common2308365
63.2%
Latin1341971
36.8%

Most frequent character per script

ValueCountFrequency (%)
1248750
10.8%
4239821
10.4%
6234868
10.2%
0234519
10.2%
3232411
10.1%
9225692
9.8%
2224476
9.7%
8223146
9.7%
5222860
9.7%
7221822
9.6%
ValueCountFrequency (%)
c240681
17.9%
a233687
17.4%
b232658
17.3%
e213586
15.9%
f211925
15.8%
d209434
15.6%

Most occurring blocks

ValueCountFrequency (%)
ASCII3650336
100.0%

Most frequent character per block

ValueCountFrequency (%)
1248750
 
6.8%
c240681
 
6.6%
4239821
 
6.6%
6234868
 
6.4%
0234519
 
6.4%
a233687
 
6.4%
b232658
 
6.4%
3232411
 
6.4%
9225692
 
6.2%
2224476
 
6.1%
Other values (6)1302773
35.7%

data_limite_envio
Categorical

HIGH CARDINALITY
UNIFORM

Distinct90127
Distinct (%)79.0%
Missing0
Missing (%)0.0%
Memory size891.3 KiB
2017-08-14 20:43:31
 
63
2017-10-05 17:44:41
 
38
2017-06-15 16:15:08
 
26
2018-02-27 12:28:15
 
24
2017-11-30 14:16:34
 
24
Other values (90122)
113898 

Length

Max length19
Median length19
Mean length19
Min length19

Characters and Unicode

Total characters2167387
Distinct characters13
Distinct categories4 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique74372 ?
Unique (%)65.2%

Sample

1st row2017-10-06 11:07:15
2nd row2017-10-06 11:07:15
3rd row2017-10-06 11:07:15
4th row2017-08-21 20:05:16
5th row2017-08-08 18:37:31
ValueCountFrequency (%)
2017-08-14 20:43:3163
 
0.1%
2017-10-05 17:44:4138
 
< 0.1%
2017-06-15 16:15:0826
 
< 0.1%
2018-02-27 12:28:1524
 
< 0.1%
2017-11-30 14:16:3424
 
< 0.1%
2017-03-15 23:39:2624
 
< 0.1%
2018-05-15 15:30:2824
 
< 0.1%
2017-07-13 15:10:1724
 
< 0.1%
2017-12-14 11:55:1722
 
< 0.1%
2017-10-24 13:06:2122
 
< 0.1%
Other values (90117)113782
99.7%
Histogram of lengths of the category
ValueCountFrequency (%)
2017-11-301695
 
0.7%
2017-12-07771
 
0.3%
2018-04-19702
 
0.3%
2018-05-10678
 
0.3%
2018-01-18665
 
0.3%
2018-08-07660
 
0.3%
2018-02-22655
 
0.3%
2018-03-08653
 
0.3%
2018-03-01650
 
0.3%
2018-03-22646
 
0.3%
Other values (39882)220371
96.6%

Most occurring characters

ValueCountFrequency (%)
0365817
16.9%
1351003
16.2%
2279255
12.9%
-228146
10.5%
:228146
10.5%
8114943
 
5.3%
114073
 
5.3%
3110065
 
5.1%
5108149
 
5.0%
798206
 
4.5%
Other values (3)169584
7.8%

Most occurring categories

ValueCountFrequency (%)
Decimal Number1597022
73.7%
Dash Punctuation228146
 
10.5%
Other Punctuation228146
 
10.5%
Space Separator114073
 
5.3%

Most frequent character per category

ValueCountFrequency (%)
0365817
22.9%
1351003
22.0%
2279255
17.5%
8114943
 
7.2%
3110065
 
6.9%
5108149
 
6.8%
798206
 
6.1%
476591
 
4.8%
647806
 
3.0%
945187
 
2.8%
ValueCountFrequency (%)
-228146
100.0%
ValueCountFrequency (%)
114073
100.0%
ValueCountFrequency (%)
:228146
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common2167387
100.0%

Most frequent character per script

ValueCountFrequency (%)
0365817
16.9%
1351003
16.2%
2279255
12.9%
-228146
10.5%
:228146
10.5%
8114943
 
5.3%
114073
 
5.3%
3110065
 
5.1%
5108149
 
5.0%
798206
 
4.5%
Other values (3)169584
7.8%

Most occurring blocks

ValueCountFrequency (%)
ASCII2167387
100.0%

Most frequent character per block

ValueCountFrequency (%)
0365817
16.9%
1351003
16.2%
2279255
12.9%
-228146
10.5%
:228146
10.5%
8114943
 
5.3%
114073
 
5.3%
3110065
 
5.1%
5108149
 
5.0%
798206
 
4.5%
Other values (3)169584
7.8%

preco
Real number (ℝ≥0)

Distinct5792
Distinct (%)5.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean120.0157796
Minimum0.85
Maximum6735
Zeros0
Zeros (%)0.0%
Memory size891.3 KiB

Quantile statistics

Minimum0.85
5-th percentile17
Q139.9
median74.9
Q3133
95-th percentile349.9
Maximum6735
Range6734.15
Interquartile range (IQR)93.1

Descriptive statistics

Standard deviation182.4031879
Coefficient of variation (CV)1.519826714
Kurtosis123.0342856
Mean120.0157796
Median Absolute Deviation (MAD)41.91
Skewness7.964132525
Sum13690560.03
Variance33270.92297
MonotocityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
59.92561
 
2.2%
69.92064
 
1.8%
49.91993
 
1.7%
89.91599
 
1.4%
99.91486
 
1.3%
29.91353
 
1.2%
39.91317
 
1.2%
19.91261
 
1.1%
79.91247
 
1.1%
29.991203
 
1.1%
Other values (5782)97989
85.9%
ValueCountFrequency (%)
0.853
 
< 0.1%
1.220
< 0.1%
2.22
 
< 0.1%
2.291
 
< 0.1%
2.91
 
< 0.1%
ValueCountFrequency (%)
67351
< 0.1%
67291
< 0.1%
64991
< 0.1%
47991
< 0.1%
46901
< 0.1%

frete
Real number (ℝ≥0)

Distinct6902
Distinct (%)6.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean20.01002604
Minimum0
Maximum409.68
Zeros386
Zeros (%)0.3%
Memory size891.3 KiB

Quantile statistics

Minimum0
5-th percentile7.78
Q113.08
median16.32
Q321.19
95-th percentile45.184
Maximum409.68
Range409.68
Interquartile range (IQR)8.11

Descriptive statistics

Standard deviation15.72648556
Coefficient of variation (CV)0.7859302897
Kurtosis58.94136685
Mean20.01002604
Median Absolute Deviation (MAD)3.63
Skewness5.577070922
Sum2282603.7
Variance247.3223481
MonotocityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
15.13721
 
3.3%
7.782255
 
2.0%
11.851920
 
1.7%
14.11900
 
1.7%
18.231587
 
1.4%
7.391534
 
1.3%
16.111178
 
1.0%
15.231034
 
0.9%
8.72917
 
0.8%
16.79898
 
0.8%
Other values (6892)97129
85.1%
ValueCountFrequency (%)
0386
0.3%
0.014
 
< 0.1%
0.023
 
< 0.1%
0.0311
 
< 0.1%
0.044
 
< 0.1%
ValueCountFrequency (%)
409.681
< 0.1%
375.282
< 0.1%
339.591
< 0.1%
338.31
< 0.1%
322.11
< 0.1%

pagamento_sequencial
Real number (ℝ≥0)

Distinct26
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.090520982
Minimum1
Maximum26
Zeros0
Zeros (%)0.0%
Memory size891.3 KiB

Quantile statistics

Minimum1
5-th percentile1
Q11
median1
Q31
95-th percentile1
Maximum26
Range25
Interquartile range (IQR)0

Descriptive statistics

Standard deviation0.6844869171
Coefficient of variation (CV)0.6276696444
Kurtosis311.8129445
Mean1.090520982
Median Absolute Deviation (MAD)0
Skewness15.14089799
Sum124399
Variance0.4685223397
MonotocityNot monotonic
Histogram with fixed size bins (bins=26)
ValueCountFrequency (%)
1109198
95.7%
23268
 
2.9%
3632
 
0.6%
4304
 
0.3%
5181
 
0.2%
6124
 
0.1%
785
 
0.1%
855
 
< 0.1%
944
 
< 0.1%
1038
 
< 0.1%
Other values (16)144
 
0.1%
ValueCountFrequency (%)
1109198
95.7%
23268
 
2.9%
3632
 
0.6%
4304
 
0.3%
5181
 
0.2%
ValueCountFrequency (%)
261
< 0.1%
251
< 0.1%
241
< 0.1%
231
< 0.1%
222
< 0.1%

tipo_pagamento
Categorical

Distinct4
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size891.3 KiB
credit_card
84183 
boleto
22189 
voucher
 
6068
debit_card
 
1633

Length

Max length11
Median length11
Mean length9.800329613
Min length6

Characters and Unicode

Total characters1117953
Distinct characters14
Distinct categories2 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowcredit_card
2nd rowvoucher
3rd rowvoucher
4th rowcredit_card
5th rowcredit_card
ValueCountFrequency (%)
credit_card84183
73.8%
boleto22189
 
19.5%
voucher6068
 
5.3%
debit_card1633
 
1.4%
Histogram of lengths of the category
ValueCountFrequency (%)
credit_card84183
73.8%
boleto22189
 
19.5%
voucher6068
 
5.3%
debit_card1633
 
1.4%

Most occurring characters

ValueCountFrequency (%)
c176067
15.7%
r176067
15.7%
d171632
15.4%
e114073
10.2%
t108005
9.7%
i85816
7.7%
_85816
7.7%
a85816
7.7%
o50446
 
4.5%
b23822
 
2.1%
Other values (4)40393
 
3.6%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter1032137
92.3%
Connector Punctuation85816
 
7.7%

Most frequent character per category

ValueCountFrequency (%)
c176067
17.1%
r176067
17.1%
d171632
16.6%
e114073
11.1%
t108005
10.5%
i85816
8.3%
a85816
8.3%
o50446
 
4.9%
b23822
 
2.3%
l22189
 
2.1%
Other values (3)18204
 
1.8%
ValueCountFrequency (%)
_85816
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin1032137
92.3%
Common85816
 
7.7%

Most frequent character per script

ValueCountFrequency (%)
c176067
17.1%
r176067
17.1%
d171632
16.6%
e114073
11.1%
t108005
10.5%
i85816
8.3%
a85816
8.3%
o50446
 
4.9%
b23822
 
2.3%
l22189
 
2.1%
Other values (3)18204
 
1.8%
ValueCountFrequency (%)
_85816
100.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII1117953
100.0%

Most frequent character per block

ValueCountFrequency (%)
c176067
15.7%
r176067
15.7%
d171632
15.4%
e114073
10.2%
t108005
9.7%
i85816
7.7%
_85816
7.7%
a85816
7.7%
o50446
 
4.5%
b23822
 
2.1%
Other values (4)40393
 
3.6%

prestacoes
Real number (ℝ≥0)

Distinct24
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.946446574
Minimum0
Maximum24
Zeros3
Zeros (%)< 0.1%
Memory size891.3 KiB

Quantile statistics

Minimum0
5-th percentile1
Q11
median2
Q34
95-th percentile10
Maximum24
Range24
Interquartile range (IQR)3

Descriptive statistics

Standard deviation2.781708287
Coefficient of variation (CV)0.9440891655
Kurtosis2.533879633
Mean2.946446574
Median Absolute Deviation (MAD)1
Skewness1.620990854
Sum336110
Variance7.737900993
MonotocityNot monotonic
Histogram with fixed size bins (bins=24)
ValueCountFrequency (%)
156810
49.8%
213244
 
11.6%
311403
 
10.0%
47756
 
6.8%
106707
 
5.9%
55863
 
5.1%
84914
 
4.3%
64491
 
3.9%
71752
 
1.5%
9705
 
0.6%
Other values (14)428
 
0.4%
ValueCountFrequency (%)
03
 
< 0.1%
156810
49.8%
213244
 
11.6%
311403
 
10.0%
47756
 
6.8%
ValueCountFrequency (%)
2434
< 0.1%
231
 
< 0.1%
221
 
< 0.1%
216
 
< 0.1%
2020
< 0.1%

valor_pagamento
Real number (ℝ≥0)

Distinct28379
Distinct (%)24.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean172.1428148
Minimum0
Maximum13664.08
Zeros4
Zeros (%)< 0.1%
Memory size891.3 KiB

Quantile statistics

Minimum0
5-th percentile27.29
Q160.95
median108.06
Q3189.37
95-th percentile512.79
Maximum13664.08
Range13664.08
Interquartile range (IQR)128.42

Descriptive statistics

Standard deviation266.1229149
Coefficient of variation (CV)1.545942625
Kurtosis531.8980401
Mean172.1428148
Median Absolute Deviation (MAD)56.6
Skewness14.46917814
Sum19636847.31
Variance70821.40583
MonotocityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
50338
 
0.3%
100293
 
0.3%
20281
 
0.2%
77.57245
 
0.2%
35162
 
0.1%
73.34158
 
0.1%
116.94132
 
0.1%
30130
 
0.1%
155.14119
 
0.1%
107.78118
 
0.1%
Other values (28369)112097
98.3%
ValueCountFrequency (%)
04
< 0.1%
0.016
< 0.1%
0.032
 
< 0.1%
0.052
 
< 0.1%
0.082
 
< 0.1%
ValueCountFrequency (%)
13664.088
< 0.1%
7274.884
< 0.1%
6929.311
 
< 0.1%
6922.211
 
< 0.1%
6726.661
 
< 0.1%

id_review
Categorical

HIGH CARDINALITY
UNIFORM

Distinct94947
Distinct (%)83.2%
Missing0
Missing (%)0.0%
Memory size891.3 KiB
eef5dbca8d37dfce6db7d7b16dd0525e
 
63
7145a6f0d38ec713897856cbdcfcdb7f
 
38
8823bba1e3301fee652eb06de8ef9435
 
26
b0c2f8c122ebef9f77753f7d167cf634
 
24
cc074f1c33940c4f0dd904705f98e39e
 
24
Other values (94942)
113898 

Length

Max length32
Median length32
Mean length32
Min length32

Characters and Unicode

Total characters3650336
Distinct characters16
Distinct categories2 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique82331 ?
Unique (%)72.2%

Sample

1st rowa54f0611adc9ed256b57ede6b6eb5114
2nd rowa54f0611adc9ed256b57ede6b6eb5114
3rd rowa54f0611adc9ed256b57ede6b6eb5114
4th rowb46f1e34512b0f4c74a72398b03ca788
5th rowdc90f19c2806f1abba9e72ad3c350073
ValueCountFrequency (%)
eef5dbca8d37dfce6db7d7b16dd0525e63
 
0.1%
7145a6f0d38ec713897856cbdcfcdb7f38
 
< 0.1%
8823bba1e3301fee652eb06de8ef943526
 
< 0.1%
b0c2f8c122ebef9f77753f7d167cf63424
 
< 0.1%
cc074f1c33940c4f0dd904705f98e39e24
 
< 0.1%
b79b22bb50f78f1afe361661011fd89224
 
< 0.1%
b5292206f96cd5d97359940203a0b51024
 
< 0.1%
7e568736c98c553aea896a5dca746d5a22
 
< 0.1%
6fe49ee0a2b00dddf7ebddb5847f928321
 
< 0.1%
e8236fe7b6e1bdd513a500de361e2b8721
 
< 0.1%
Other values (94937)113786
99.7%
Histogram of lengths of the category
ValueCountFrequency (%)
eef5dbca8d37dfce6db7d7b16dd0525e63
 
0.1%
7145a6f0d38ec713897856cbdcfcdb7f38
 
< 0.1%
8823bba1e3301fee652eb06de8ef943526
 
< 0.1%
b0c2f8c122ebef9f77753f7d167cf63424
 
< 0.1%
cc074f1c33940c4f0dd904705f98e39e24
 
< 0.1%
b79b22bb50f78f1afe361661011fd89224
 
< 0.1%
b5292206f96cd5d97359940203a0b51024
 
< 0.1%
7e568736c98c553aea896a5dca746d5a22
 
< 0.1%
6fe49ee0a2b00dddf7ebddb5847f928321
 
< 0.1%
e8236fe7b6e1bdd513a500de361e2b8721
 
< 0.1%
Other values (94937)113786
99.7%

Most occurring characters

ValueCountFrequency (%)
6229112
 
6.3%
a228833
 
6.3%
5228589
 
6.3%
d228554
 
6.3%
f228423
 
6.3%
b228389
 
6.3%
8228308
 
6.3%
1228150
 
6.3%
0228145
 
6.2%
c228031
 
6.2%
Other values (6)1365802
37.4%

Most occurring categories

ValueCountFrequency (%)
Decimal Number2280313
62.5%
Lowercase Letter1370023
37.5%

Most frequent character per category

ValueCountFrequency (%)
6229112
10.0%
5228589
10.0%
8228308
10.0%
1228150
10.0%
0228145
10.0%
7228023
10.0%
2227863
10.0%
9227603
10.0%
4227271
10.0%
3227249
10.0%
ValueCountFrequency (%)
a228833
16.7%
d228554
16.7%
f228423
16.7%
b228389
16.7%
c228031
16.6%
e227793
16.6%

Most occurring scripts

ValueCountFrequency (%)
Common2280313
62.5%
Latin1370023
37.5%

Most frequent character per script

ValueCountFrequency (%)
6229112
10.0%
5228589
10.0%
8228308
10.0%
1228150
10.0%
0228145
10.0%
7228023
10.0%
2227863
10.0%
9227603
10.0%
4227271
10.0%
3227249
10.0%
ValueCountFrequency (%)
a228833
16.7%
d228554
16.7%
f228423
16.7%
b228389
16.7%
c228031
16.6%
e227793
16.6%

Most occurring blocks

ValueCountFrequency (%)
ASCII3650336
100.0%

Most frequent character per block

ValueCountFrequency (%)
6229112
 
6.3%
a228833
 
6.3%
5228589
 
6.3%
d228554
 
6.3%
f228423
 
6.3%
b228389
 
6.3%
8228308
 
6.3%
1228150
 
6.3%
0228145
 
6.2%
c228031
 
6.2%
Other values (6)1365802
37.4%

review_score
Categorical

Distinct5
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size891.3 KiB
5
65250 
4
21878 
1
13352 
3
9647 
2
 
3946

Length

Max length1
Median length1
Mean length1
Min length1

Characters and Unicode

Total characters114073
Distinct characters5
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row4
2nd row4
3rd row4
4th row4
5th row5
ValueCountFrequency (%)
565250
57.2%
421878
 
19.2%
113352
 
11.7%
39647
 
8.5%
23946
 
3.5%
Histogram of lengths of the category
ValueCountFrequency (%)
565250
57.2%
421878
 
19.2%
113352
 
11.7%
39647
 
8.5%
23946
 
3.5%

Most occurring characters

ValueCountFrequency (%)
565250
57.2%
421878
 
19.2%
113352
 
11.7%
39647
 
8.5%
23946
 
3.5%

Most occurring categories

ValueCountFrequency (%)
Decimal Number114073
100.0%

Most frequent character per category

ValueCountFrequency (%)
565250
57.2%
421878
 
19.2%
113352
 
11.7%
39647
 
8.5%
23946
 
3.5%

Most occurring scripts

ValueCountFrequency (%)
Common114073
100.0%

Most frequent character per script

ValueCountFrequency (%)
565250
57.2%
421878
 
19.2%
113352
 
11.7%
39647
 
8.5%
23946
 
3.5%

Most occurring blocks

ValueCountFrequency (%)
ASCII114073
100.0%

Most frequent character per block

ValueCountFrequency (%)
565250
57.2%
421878
 
19.2%
113352
 
11.7%
39647
 
8.5%
23946
 
3.5%

titulo_review
Categorical

HIGH CARDINALITY
MISSING

Distinct4409
Distinct (%)32.3%
Missing100406
Missing (%)88.0%
Memory size891.3 KiB
Recomendo
 
492
recomendo
 
399
Bom
 
328
super recomendo
 
311
Excelente
 
293
Other values (4404)
11844 

Length

Max length26
Median length11
Mean length12.15841077
Min length1

Characters and Unicode

Total characters166169
Distinct characters125
Distinct categories13 ?
Distinct scripts2 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique3001 ?
Unique (%)22.0%

Sample

1st rowMuito boa a loja
2nd rowsuper recomendo
3rd rowMuito bom
4th rowsuper recomendo
5th rowsuper recomendo
ValueCountFrequency (%)
Recomendo492
 
0.4%
recomendo399
 
0.3%
Bom328
 
0.3%
super recomendo311
 
0.3%
Excelente293
 
0.3%
Muito bom277
 
0.2%
Ótimo266
 
0.2%
Super recomendo251
 
0.2%
Ótimo 234
 
0.2%
Otimo201
 
0.2%
Other values (4399)10615
 
9.3%
(Missing)100406
88.0%
Histogram of lengths of the category
ValueCountFrequency (%)
recomendo2432
 
9.4%
bom1517
 
5.8%
produto1507
 
5.8%
super1035
 
4.0%
muito1030
 
4.0%
não832
 
3.2%
ótimo799
 
3.1%
excelente762
 
2.9%
entrega693
 
2.7%
otimo417
 
1.6%
Other values (2051)14976
57.6%

Most occurring characters

ValueCountFrequency (%)
o20694
 
12.5%
e17800
 
10.7%
14688
 
8.8%
r9615
 
5.8%
t9217
 
5.5%
a8903
 
5.4%
m8252
 
5.0%
d8016
 
4.8%
i7885
 
4.7%
n7412
 
4.5%
Other values (115)53687
32.3%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter129186
77.7%
Uppercase Letter18340
 
11.0%
Space Separator14688
 
8.8%
Other Punctuation2631
 
1.6%
Decimal Number1224
 
0.7%
Other Symbol49
 
< 0.1%
Dash Punctuation16
 
< 0.1%
Modifier Symbol13
 
< 0.1%
Math Symbol8
 
< 0.1%
Close Punctuation7
 
< 0.1%
Other values (3)7
 
< 0.1%

Most frequent character per category

ValueCountFrequency (%)
o20694
16.0%
e17800
13.8%
r9615
 
7.4%
t9217
 
7.1%
a8903
 
6.9%
m8252
 
6.4%
d8016
 
6.2%
i7885
 
6.1%
n7412
 
5.7%
c5789
 
4.5%
Other values (31)25603
19.8%
ValueCountFrequency (%)
E2480
13.5%
R2001
10.9%
O1627
 
8.9%
P1552
 
8.5%
M1429
 
7.8%
N1118
 
6.1%
S1036
 
5.6%
A937
 
5.1%
Ó924
 
5.0%
B889
 
4.8%
Other values (26)4347
23.7%
ValueCountFrequency (%)
!1185
45.0%
.785
29.8%
*396
 
15.1%
,151
 
5.7%
?43
 
1.6%
/33
 
1.3%
%19
 
0.7%
:6
 
0.2%
;4
 
0.2%
"3
 
0.1%
Other values (4)6
 
0.2%
ValueCountFrequency (%)
👍16
32.7%
😍9
18.4%
👏7
14.3%
🌟6
 
12.2%
💥5
 
10.2%
🚚1
 
2.0%
🔟1
 
2.0%
😀1
 
2.0%
🤗1
 
2.0%
👎1
 
2.0%
ValueCountFrequency (%)
0465
38.0%
1419
34.2%
576
 
6.2%
272
 
5.9%
845
 
3.7%
341
 
3.3%
439
 
3.2%
929
 
2.4%
722
 
1.8%
616
 
1.3%
ValueCountFrequency (%)
´6
46.2%
🏻3
23.1%
🏽2
 
15.4%
🏼2
 
15.4%
ValueCountFrequency (%)
+7
87.5%
=1
 
12.5%
ValueCountFrequency (%)
)6
85.7%
]1
 
14.3%
ValueCountFrequency (%)
14688
100.0%
ValueCountFrequency (%)
-16
100.0%
ValueCountFrequency (%)
(1
100.0%
ValueCountFrequency (%)
ª1
100.0%
ValueCountFrequency (%)
$5
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin147527
88.8%
Common18642
 
11.2%

Most frequent character per script

ValueCountFrequency (%)
o20694
14.0%
e17800
12.1%
r9615
 
6.5%
t9217
 
6.2%
a8903
 
6.0%
m8252
 
5.6%
d8016
 
5.4%
i7885
 
5.3%
n7412
 
5.0%
c5789
 
3.9%
Other values (68)43944
29.8%
ValueCountFrequency (%)
14688
78.8%
!1185
 
6.4%
.785
 
4.2%
0465
 
2.5%
1419
 
2.2%
*396
 
2.1%
,151
 
0.8%
576
 
0.4%
272
 
0.4%
845
 
0.2%
Other values (37)360
 
1.9%

Most occurring blocks

ValueCountFrequency (%)
ASCII162679
97.9%
None3479
 
2.1%
Emoticons11
 
< 0.1%

Most frequent character per block

ValueCountFrequency (%)
o20694
12.7%
e17800
 
10.9%
14688
 
9.0%
r9615
 
5.9%
t9217
 
5.7%
a8903
 
5.5%
m8252
 
5.1%
d8016
 
4.9%
i7885
 
4.8%
n7412
 
4.6%
Other values (74)50197
30.9%
ValueCountFrequency (%)
ã1013
29.1%
Ó924
26.6%
á354
 
10.2%
ç341
 
9.8%
é253
 
7.3%
ó245
 
7.0%
Ã65
 
1.9%
í61
 
1.8%
ê41
 
1.2%
É30
 
0.9%
Other values (28)152
 
4.4%
ValueCountFrequency (%)
😍9
81.8%
😀1
 
9.1%
😤1
 
9.1%

comentario_review
Categorical

HIGH CARDINALITY
MISSING

Distinct34589
Distinct (%)71.7%
Missing65847
Missing (%)57.7%
Memory size891.3 KiB
Muito bom
 
253
Bom
 
206
muito bom
 
135
bom
 
115
Otimo
 
114
Other values (34584)
47403 

Length

Max length208
Median length55
Mean length70.80174595
Min length1

Characters and Unicode

Total characters3414485
Distinct characters208
Distinct categories15 ?
Distinct scripts2 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique28172 ?
Unique (%)58.4%

Sample

1st rowNão testei o produto ainda, mas ele veio correto e em boas condições. Apenas a caixa que veio bem amassada e danificada, o que ficará chato, pois se trata de um presente.
2nd rowNão testei o produto ainda, mas ele veio correto e em boas condições. Apenas a caixa que veio bem amassada e danificada, o que ficará chato, pois se trata de um presente.
3rd rowNão testei o produto ainda, mas ele veio correto e em boas condições. Apenas a caixa que veio bem amassada e danificada, o que ficará chato, pois se trata de um presente.
4th rowDeveriam embalar melhor o produto. A caixa veio toda amassada e vou dar de presente.
5th rowSó achei ela pequena pra seis xícaras ,mais é um bom produto
ValueCountFrequency (%)
Muito bom253
 
0.2%
Bom206
 
0.2%
muito bom135
 
0.1%
bom115
 
0.1%
Otimo114
 
0.1%
Recomendo108
 
0.1%
otimo102
 
0.1%
Ok87
 
0.1%
Ótimo84
 
0.1%
Ótimo 82
 
0.1%
Other values (34579)46940
41.1%
(Missing)65847
57.7%
Histogram of lengths of the category
ValueCountFrequency (%)
o21645
 
3.7%
produto20063
 
3.4%
e19229
 
3.3%
a14594
 
2.5%
de14021
 
2.4%
do12727
 
2.2%
não12028
 
2.1%
que10069
 
1.7%
prazo9137
 
1.6%
muito8959
 
1.5%
Other values (19513)439641
75.5%

Most occurring characters

ValueCountFrequency (%)
540024
15.8%
o335858
 
9.8%
e327292
 
9.6%
a269792
 
7.9%
r191802
 
5.6%
i157267
 
4.6%
t155267
 
4.5%
d144525
 
4.2%
n131696
 
3.9%
s128449
 
3.8%
Other values (198)1032513
30.2%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter2574732
75.4%
Space Separator540024
 
15.8%
Uppercase Letter165143
 
4.8%
Other Punctuation93322
 
2.7%
Decimal Number23872
 
0.7%
Control13763
 
0.4%
Dash Punctuation1080
 
< 0.1%
Close Punctuation735
 
< 0.1%
Open Punctuation717
 
< 0.1%
Other Symbol704
 
< 0.1%
Other values (5)393
 
< 0.1%

Most frequent character per category

ValueCountFrequency (%)
👏242
34.4%
👍86
 
12.2%
😍74
 
10.5%
°32
 
4.5%
😡22
 
3.1%
😉22
 
3.1%
😘20
 
2.8%
😆19
 
2.7%
👎15
 
2.1%
😁13
 
1.8%
Other values (54)159
22.6%
ValueCountFrequency (%)
o335858
13.0%
e327292
12.7%
a269792
10.5%
r191802
 
7.4%
i157267
 
6.1%
t155267
 
6.0%
d144525
 
5.6%
n131696
 
5.1%
s128449
 
5.0%
m123372
 
4.8%
Other values (39)609412
23.7%
ValueCountFrequency (%)
E19586
11.9%
O18433
11.2%
A16975
10.3%
P12254
 
7.4%
R12031
 
7.3%
C9635
 
5.8%
N9233
 
5.6%
M9227
 
5.6%
S8166
 
4.9%
T7774
 
4.7%
Other values (31)41829
25.3%
ValueCountFrequency (%)
.49058
52.6%
,27526
29.5%
!12219
 
13.1%
/1681
 
1.8%
?1523
 
1.6%
"401
 
0.4%
:348
 
0.4%
;219
 
0.2%
%192
 
0.2%
*76
 
0.1%
Other values (6)79
 
0.1%
ValueCountFrequency (%)
05182
21.7%
15076
21.3%
24341
18.2%
32396
10.0%
41586
 
6.6%
51415
 
5.9%
61149
 
4.8%
81093
 
4.6%
7924
 
3.9%
9710
 
3.0%
ValueCountFrequency (%)
+86
59.7%
=29
 
20.1%
|12
 
8.3%
<9
 
6.2%
~3
 
2.1%
>2
 
1.4%
×2
 
1.4%
÷1
 
0.7%
ValueCountFrequency (%)
🏻34
33.3%
´26
25.5%
🏼15
14.7%
🏽13
 
12.7%
^8
 
7.8%
🏾4
 
3.9%
`2
 
2.0%
ValueCountFrequency (%)
6874
49.9%
6868
49.9%
21
 
0.2%
ValueCountFrequency (%)
(711
99.2%
[6
 
0.8%
ValueCountFrequency (%)
)733
99.7%
]2
 
0.3%
ValueCountFrequency (%)
º29
61.7%
ª18
38.3%
ValueCountFrequency (%)
540024
100.0%
ValueCountFrequency (%)
_14
100.0%
ValueCountFrequency (%)
-1080
100.0%
ValueCountFrequency (%)
$86
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin2739922
80.2%
Common674563
 
19.8%

Most frequent character per script

ValueCountFrequency (%)
540024
80.1%
.49058
 
7.3%
,27526
 
4.1%
!12219
 
1.8%
6874
 
1.0%
6868
 
1.0%
05182
 
0.8%
15076
 
0.8%
24341
 
0.6%
32396
 
0.4%
Other values (106)14999
 
2.2%
ValueCountFrequency (%)
o335858
12.3%
e327292
11.9%
a269792
 
9.8%
r191802
 
7.0%
i157267
 
5.7%
t155267
 
5.7%
d144525
 
5.3%
n131696
 
4.8%
s128449
 
4.7%
m123372
 
4.5%
Other values (82)774602
28.3%

Most occurring blocks

ValueCountFrequency (%)
ASCII3352823
98.2%
None61412
 
1.8%
Emoticons250
 
< 0.1%

Most frequent character per block

ValueCountFrequency (%)
540024
16.1%
o335858
 
10.0%
e327292
 
9.8%
a269792
 
8.0%
r191802
 
5.7%
i157267
 
4.7%
t155267
 
4.6%
d144525
 
4.3%
n131696
 
3.9%
s128449
 
3.8%
Other values (86)970851
29.0%
ValueCountFrequency (%)
ã17535
28.6%
é11081
18.0%
á8821
14.4%
ç7486
12.2%
ó6255
 
10.2%
ê1859
 
3.0%
í1708
 
2.8%
Ó1547
 
2.5%
õ904
 
1.5%
ú892
 
1.5%
Other values (71)3324
 
5.4%
ValueCountFrequency (%)
😍74
29.6%
😡22
 
8.8%
😉22
 
8.8%
😘20
 
8.0%
😆19
 
7.6%
😁13
 
5.2%
😊12
 
4.8%
😀8
 
3.2%
😩7
 
2.8%
😃6
 
2.4%
Other values (21)47
18.8%

data_criacao_review
Categorical

HIGH CARDINALITY

Distinct627
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size891.3 KiB
2017-12-19 00:00:00
 
526
2018-05-15 00:00:00
 
521
2018-05-22 00:00:00
 
520
2018-08-28 00:00:00
 
502
2017-12-20 00:00:00
 
501
Other values (622)
111503 

Length

Max length19
Median length19
Mean length19
Min length19

Characters and Unicode

Total characters2167387
Distinct characters13
Distinct categories4 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique27 ?
Unique (%)< 0.1%

Sample

1st row2017-10-11 00:00:00
2nd row2017-10-11 00:00:00
3rd row2017-10-11 00:00:00
4th row2017-08-19 00:00:00
5th row2017-08-08 00:00:00
ValueCountFrequency (%)
2017-12-19 00:00:00526
 
0.5%
2018-05-15 00:00:00521
 
0.5%
2018-05-22 00:00:00520
 
0.5%
2018-08-28 00:00:00502
 
0.4%
2017-12-20 00:00:00501
 
0.4%
2018-05-04 00:00:00497
 
0.4%
2018-05-19 00:00:00493
 
0.4%
2018-03-29 00:00:00490
 
0.4%
2018-08-14 00:00:00480
 
0.4%
2017-12-13 00:00:00474
 
0.4%
Other values (617)109069
95.6%
Histogram of lengths of the category
ValueCountFrequency (%)
00:00:00113981
50.0%
2017-12-19526
 
0.2%
2018-05-15521
 
0.2%
2018-05-22520
 
0.2%
2018-08-28502
 
0.2%
2017-12-20501
 
0.2%
2018-05-04497
 
0.2%
2018-05-19493
 
0.2%
2018-03-29490
 
0.2%
2018-08-14480
 
0.2%
Other values (619)109635
48.1%

Most occurring characters

ValueCountFrequency (%)
0940260
43.4%
-228146
 
10.5%
:228146
 
10.5%
1197907
 
9.1%
2182136
 
8.4%
114073
 
5.3%
891669
 
4.2%
771428
 
3.3%
327906
 
1.3%
524447
 
1.1%
Other values (3)61269
 
2.8%

Most occurring categories

ValueCountFrequency (%)
Decimal Number1597022
73.7%
Dash Punctuation228146
 
10.5%
Other Punctuation228146
 
10.5%
Space Separator114073
 
5.3%

Most frequent character per category

ValueCountFrequency (%)
0940260
58.9%
1197907
 
12.4%
2182136
 
11.4%
891669
 
5.7%
771428
 
4.5%
327906
 
1.7%
524447
 
1.5%
422902
 
1.4%
622694
 
1.4%
915673
 
1.0%
ValueCountFrequency (%)
-228146
100.0%
ValueCountFrequency (%)
114073
100.0%
ValueCountFrequency (%)
:228146
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common2167387
100.0%

Most frequent character per script

ValueCountFrequency (%)
0940260
43.4%
-228146
 
10.5%
:228146
 
10.5%
1197907
 
9.1%
2182136
 
8.4%
114073
 
5.3%
891669
 
4.2%
771428
 
3.3%
327906
 
1.3%
524447
 
1.1%
Other values (3)61269
 
2.8%

Most occurring blocks

ValueCountFrequency (%)
ASCII2167387
100.0%

Most frequent character per block

ValueCountFrequency (%)
0940260
43.4%
-228146
 
10.5%
:228146
 
10.5%
1197907
 
9.1%
2182136
 
8.4%
114073
 
5.3%
891669
 
4.2%
771428
 
3.3%
327906
 
1.3%
524447
 
1.1%
Other values (3)61269
 
2.8%

data_resposta_review
Categorical

HIGH CARDINALITY
UNIFORM

Distinct94800
Distinct (%)83.1%
Missing0
Missing (%)0.0%
Memory size891.3 KiB
2017-08-17 22:17:55
 
63
2017-10-19 21:08:44
 
38
2017-06-28 18:49:50
 
26
2018-06-04 19:04:20
 
24
2018-03-07 15:08:10
 
24
Other values (94795)
113898 

Length

Max length19
Median length19
Mean length19
Min length19

Characters and Unicode

Total characters2167387
Distinct characters13
Distinct categories4 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique82080 ?
Unique (%)72.0%

Sample

1st row2017-10-12 03:43:48
2nd row2017-10-12 03:43:48
3rd row2017-10-12 03:43:48
4th row2017-08-20 15:16:36
5th row2017-08-08 23:26:23
ValueCountFrequency (%)
2017-08-17 22:17:5563
 
0.1%
2017-10-19 21:08:4438
 
< 0.1%
2017-06-28 18:49:5026
 
< 0.1%
2018-06-04 19:04:2024
 
< 0.1%
2018-03-07 15:08:1024
 
< 0.1%
2017-03-23 08:34:1324
 
< 0.1%
2017-08-01 13:20:3124
 
< 0.1%
2017-12-22 20:33:5222
 
< 0.1%
2018-06-15 19:25:5521
 
< 0.1%
2018-02-19 20:04:3621
 
< 0.1%
Other values (94790)113786
99.7%
Histogram of lengths of the category
ValueCountFrequency (%)
2018-05-20757
 
0.3%
2018-05-21679
 
0.3%
2018-05-10577
 
0.3%
2017-12-20465
 
0.2%
2017-12-13417
 
0.2%
2018-05-11415
 
0.2%
2018-04-13412
 
0.2%
2018-08-24406
 
0.2%
2017-12-22400
 
0.2%
2017-12-21398
 
0.2%
Other values (52941)223220
97.8%

Most occurring characters

ValueCountFrequency (%)
0365214
16.9%
1337956
15.6%
2289281
13.3%
-228146
10.5%
:228146
10.5%
8120505
 
5.6%
114073
 
5.3%
3105945
 
4.9%
798302
 
4.5%
590353
 
4.2%
Other values (3)189466
8.7%

Most occurring categories

ValueCountFrequency (%)
Decimal Number1597022
73.7%
Dash Punctuation228146
 
10.5%
Other Punctuation228146
 
10.5%
Space Separator114073
 
5.3%

Most frequent character per category

ValueCountFrequency (%)
0365214
22.9%
1337956
21.2%
2289281
18.1%
8120505
 
7.5%
3105945
 
6.6%
798302
 
6.2%
590353
 
5.7%
490021
 
5.6%
651470
 
3.2%
947975
 
3.0%
ValueCountFrequency (%)
-228146
100.0%
ValueCountFrequency (%)
114073
100.0%
ValueCountFrequency (%)
:228146
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common2167387
100.0%

Most frequent character per script

ValueCountFrequency (%)
0365214
16.9%
1337956
15.6%
2289281
13.3%
-228146
10.5%
:228146
10.5%
8120505
 
5.6%
114073
 
5.3%
3105945
 
4.9%
798302
 
4.5%
590353
 
4.2%
Other values (3)189466
8.7%

Most occurring blocks

ValueCountFrequency (%)
ASCII2167387
100.0%

Most frequent character per block

ValueCountFrequency (%)
0365214
16.9%
1337956
15.6%
2289281
13.3%
-228146
10.5%
:228146
10.5%
8120505
 
5.6%
114073
 
5.3%
3105945
 
4.9%
798302
 
4.5%
590353
 
4.2%
Other values (3)189466
8.7%

categoria_produto
Categorical

HIGH CARDINALITY

Distinct73
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size891.3 KiB
cama_mesa_banho
11815 
beleza_saude
9816 
esporte_lazer
8790 
moveis_decoracao
8640 
informatica_acessorios
7963 
Other values (68)
67049 

Length

Max length46
Median length15
Mean length14.87437869
Min length3

Characters and Unicode

Total characters1696765
Distinct characters28
Distinct categories3 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowutilidades_domesticas
2nd rowutilidades_domesticas
3rd rowutilidades_domesticas
4th rowutilidades_domesticas
5th rowutilidades_domesticas
ValueCountFrequency (%)
cama_mesa_banho11815
 
10.4%
beleza_saude9816
 
8.6%
esporte_lazer8790
 
7.7%
moveis_decoracao8640
 
7.6%
informatica_acessorios7963
 
7.0%
utilidades_domesticas7196
 
6.3%
relogios_presentes6075
 
5.3%
telefonia4605
 
4.0%
ferramentas_jardim4479
 
3.9%
automotivo4301
 
3.8%
Other values (63)40393
35.4%
Histogram of lengths of the category
ValueCountFrequency (%)
cama_mesa_banho11815
 
10.4%
beleza_saude9816
 
8.6%
esporte_lazer8790
 
7.7%
moveis_decoracao8640
 
7.6%
informatica_acessorios7963
 
7.0%
utilidades_domesticas7196
 
6.3%
relogios_presentes6075
 
5.3%
telefonia4605
 
4.0%
ferramentas_jardim4479
 
3.9%
automotivo4301
 
3.8%
Other values (63)40393
35.4%

Most occurring characters

ValueCountFrequency (%)
e205827
12.1%
a204478
12.1%
s169017
10.0%
o167967
9.9%
i112530
 
6.6%
r108962
 
6.4%
_108191
 
6.4%
t81385
 
4.8%
c80755
 
4.8%
m77055
 
4.5%
Other values (18)380598
22.4%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter1588279
93.6%
Connector Punctuation108191
 
6.4%
Decimal Number295
 
< 0.1%

Most frequent character per category

ValueCountFrequency (%)
e205827
13.0%
a204478
12.9%
s169017
10.6%
o167967
10.6%
i112530
 
7.1%
r108962
 
6.9%
t81385
 
5.1%
c80755
 
5.1%
m77055
 
4.9%
n57892
 
3.6%
Other values (16)322411
20.3%
ValueCountFrequency (%)
_108191
100.0%
ValueCountFrequency (%)
2295
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin1588279
93.6%
Common108486
 
6.4%

Most frequent character per script

ValueCountFrequency (%)
e205827
13.0%
a204478
12.9%
s169017
10.6%
o167967
10.6%
i112530
 
7.1%
r108962
 
6.9%
t81385
 
5.1%
c80755
 
5.1%
m77055
 
4.9%
n57892
 
3.6%
Other values (16)322411
20.3%
ValueCountFrequency (%)
_108191
99.7%
2295
 
0.3%

Most occurring blocks

ValueCountFrequency (%)
ASCII1696765
100.0%

Most frequent character per block

ValueCountFrequency (%)
e205827
12.1%
a204478
12.1%
s169017
10.0%
o167967
9.9%
i112530
 
6.6%
r108962
 
6.4%
_108191
 
6.4%
t81385
 
4.8%
c80755
 
4.8%
m77055
 
4.5%
Other values (18)380598
22.4%

qtd_fotos_produto
Real number (ℝ≥0)

Distinct19
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.206481814
Minimum1
Maximum20
Zeros0
Zeros (%)0.0%
Memory size891.3 KiB

Quantile statistics

Minimum1
5-th percentile1
Q11
median1
Q33
95-th percentile6
Maximum20
Range19
Interquartile range (IQR)2

Descriptive statistics

Standard deviation1.718005821
Coefficient of variation (CV)0.7786177117
Kurtosis4.755824682
Mean2.206481814
Median Absolute Deviation (MAD)0
Skewness1.902739279
Sum251700
Variance2.951544002
MonotocityNot monotonic
Histogram with fixed size bins (bins=19)
ValueCountFrequency (%)
157640
50.5%
222552
 
19.8%
312716
 
11.1%
48663
 
7.6%
55492
 
4.8%
63869
 
3.4%
71529
 
1.3%
8760
 
0.7%
10347
 
0.3%
9309
 
0.3%
Other values (9)196
 
0.2%
ValueCountFrequency (%)
157640
50.5%
222552
 
19.8%
312716
 
11.1%
48663
 
7.6%
55492
 
4.8%
ValueCountFrequency (%)
201
 
< 0.1%
191
 
< 0.1%
184
 
< 0.1%
1711
< 0.1%
1511
< 0.1%

peso_produto
Real number (ℝ≥0)

Distinct2169
Distinct (%)1.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2108.578051
Minimum0
Maximum40425
Zeros8
Zeros (%)< 0.1%
Memory size891.3 KiB

Quantile statistics

Minimum0
5-th percentile125
Q1300
median700
Q31800
95-th percentile9800
Maximum40425
Range40425
Interquartile range (IQR)1500

Descriptive statistics

Standard deviation3768.377345
Coefficient of variation (CV)1.787165215
Kurtosis16.1212629
Mean2108.578051
Median Absolute Deviation (MAD)500
Skewness3.586967024
Sum240531824
Variance14200667.82
MonotocityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
2006757
 
5.9%
1505293
 
4.6%
2504620
 
4.1%
3004246
 
3.7%
1003509
 
3.1%
4003425
 
3.0%
3503184
 
2.8%
6002742
 
2.4%
5002723
 
2.4%
7002078
 
1.8%
Other values (2159)75496
66.2%
ValueCountFrequency (%)
08
 
< 0.1%
25
 
< 0.1%
253
 
< 0.1%
50915
0.8%
532
 
< 0.1%
ValueCountFrequency (%)
404253
 
< 0.1%
30000290
0.3%
298001
 
< 0.1%
297003
 
< 0.1%
296005
 
< 0.1%

comprimento_produto
Real number (ℝ≥0)

Distinct99
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean30.28853453
Minimum7
Maximum105
Zeros0
Zeros (%)0.0%
Memory size891.3 KiB

Quantile statistics

Minimum7
5-th percentile16
Q118
median25
Q338
95-th percentile62
Maximum105
Range98
Interquartile range (IQR)20

Descriptive statistics

Standard deviation16.15736235
Coefficient of variation (CV)0.533448138
Kurtosis3.62841728
Mean30.28853453
Median Absolute Deviation (MAD)8
Skewness1.733817354
Sum3455104
Variance261.0603581
MonotocityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1617500
 
15.3%
2010443
 
9.2%
307732
 
6.8%
176039
 
5.3%
185710
 
5.0%
194786
 
4.2%
254724
 
4.1%
404178
 
3.7%
223887
 
3.4%
503051
 
2.7%
Other values (89)46023
40.3%
ValueCountFrequency (%)
732
 
< 0.1%
82
 
< 0.1%
94
 
< 0.1%
108
 
< 0.1%
1196
0.1%
ValueCountFrequency (%)
105311
0.3%
10435
 
< 0.1%
10345
 
< 0.1%
10260
 
0.1%
101107
 
0.1%

altura_produto
Real number (ℝ≥0)

Distinct102
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean16.60698851
Minimum2
Maximum105
Zeros0
Zeros (%)0.0%
Memory size891.3 KiB

Quantile statistics

Minimum2
5-th percentile3
Q18
median13
Q320
95-th percentile45
Maximum105
Range103
Interquartile range (IQR)12

Descriptive statistics

Standard deviation13.43962315
Coefficient of variation (CV)0.8092751519
Kurtosis7.284949109
Mean16.60698851
Median Absolute Deviation (MAD)6
Skewness2.242525757
Sum1894409
Variance180.6234703
MonotocityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1010091
 
8.8%
156698
 
5.9%
206684
 
5.9%
116218
 
5.5%
126143
 
5.4%
25029
 
4.4%
44724
 
4.1%
84716
 
4.1%
164611
 
4.0%
54572
 
4.0%
Other values (92)54587
47.9%
ValueCountFrequency (%)
25029
4.4%
32748
2.4%
44724
4.1%
54572
4.0%
63478
3.0%
ValueCountFrequency (%)
105134
0.1%
10412
 
< 0.1%
10349
 
< 0.1%
10210
 
< 0.1%
10040
 
< 0.1%

largura_produto
Real number (ℝ≥0)

Distinct94
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean23.1050906
Minimum6
Maximum118
Zeros0
Zeros (%)0.0%
Memory size891.3 KiB

Quantile statistics

Minimum6
5-th percentile11
Q115
median20
Q330
95-th percentile45
Maximum118
Range112
Interquartile range (IQR)15

Descriptive statistics

Standard deviation11.73968495
Coefficient of variation (CV)0.5080994988
Kurtosis4.560336619
Mean23.1050906
Median Absolute Deviation (MAD)6
Skewness1.705271877
Sum2635667
Variance137.8202028
MonotocityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
2012285
 
10.8%
1110522
 
9.2%
158836
 
7.7%
168564
 
7.5%
307803
 
6.8%
125515
 
4.8%
135354
 
4.7%
144694
 
4.1%
184071
 
3.6%
403999
 
3.5%
Other values (84)42430
37.2%
ValueCountFrequency (%)
62
 
< 0.1%
75
 
< 0.1%
829
 
< 0.1%
949
< 0.1%
1081
0.1%
ValueCountFrequency (%)
1188
< 0.1%
10513
< 0.1%
1041
 
< 0.1%
1022
 
< 0.1%
1012
 
< 0.1%

id_unico_consumidor
Categorical

HIGH CARDINALITY
UNIFORM

Distinct92081
Distinct (%)80.7%
Missing0
Missing (%)0.0%
Memory size891.3 KiB
9a736b248f67d166d2fbb006bcb877c3
 
75
6fbc7cdadbb522125f4b27ae9dee4060
 
38
f9ae226291893fda10af7965268fb7f6
 
35
569aa12b73b5f7edeaa6f2a01603e381
 
26
1d2435aa3b858d45c707c9fc25e18779
 
24
Other values (92076)
113875 

Length

Max length32
Median length32
Mean length32
Min length32

Characters and Unicode

Total characters3650336
Distinct characters16
Distinct categories2 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique78205 ?
Unique (%)68.6%

Sample

1st row7c396fd4830fd04220f754e42b4e5bff
2nd row7c396fd4830fd04220f754e42b4e5bff
3rd row7c396fd4830fd04220f754e42b4e5bff
4th row3a51803cc0d012c3b5dc8b7528cb05f7
5th rowef0996a1a279c26e7ecbd737be23d235
ValueCountFrequency (%)
9a736b248f67d166d2fbb006bcb877c375
 
0.1%
6fbc7cdadbb522125f4b27ae9dee406038
 
< 0.1%
f9ae226291893fda10af7965268fb7f635
 
< 0.1%
569aa12b73b5f7edeaa6f2a01603e38126
 
< 0.1%
1d2435aa3b858d45c707c9fc25e1877924
 
< 0.1%
d97b3cfb22b0d6b25ac9ed4e9c2d481b24
 
< 0.1%
5419a7c9b86a43d8140e2939cd2c2f7e24
 
< 0.1%
db1af3fd6b23ac3873ef02619d548f9c24
 
< 0.1%
85963fd37bfd387aa6d915d8a106548624
 
< 0.1%
90807fdb59eec2152bc977feeb6e47e724
 
< 0.1%
Other values (92071)113755
99.7%
Histogram of lengths of the category
ValueCountFrequency (%)
9a736b248f67d166d2fbb006bcb877c375
 
0.1%
6fbc7cdadbb522125f4b27ae9dee406038
 
< 0.1%
f9ae226291893fda10af7965268fb7f635
 
< 0.1%
569aa12b73b5f7edeaa6f2a01603e38126
 
< 0.1%
1d2435aa3b858d45c707c9fc25e1877924
 
< 0.1%
d97b3cfb22b0d6b25ac9ed4e9c2d481b24
 
< 0.1%
5419a7c9b86a43d8140e2939cd2c2f7e24
 
< 0.1%
db1af3fd6b23ac3873ef02619d548f9c24
 
< 0.1%
85963fd37bfd387aa6d915d8a106548624
 
< 0.1%
90807fdb59eec2152bc977feeb6e47e724
 
< 0.1%
Other values (92071)113755
99.7%

Most occurring characters

ValueCountFrequency (%)
6229236
 
6.3%
1228583
 
6.3%
b228569
 
6.3%
a228376
 
6.3%
d228355
 
6.3%
e228263
 
6.3%
3228249
 
6.3%
9228192
 
6.3%
5228173
 
6.3%
8228109
 
6.2%
Other values (6)1366231
37.4%

Most occurring categories

ValueCountFrequency (%)
Decimal Number2281577
62.5%
Lowercase Letter1368759
37.5%

Most frequent character per category

ValueCountFrequency (%)
6229236
10.0%
1228583
10.0%
3228249
10.0%
9228192
10.0%
5228173
10.0%
8228109
10.0%
2228085
10.0%
7227968
10.0%
0227741
10.0%
4227241
10.0%
ValueCountFrequency (%)
b228569
16.7%
a228376
16.7%
d228355
16.7%
e228263
16.7%
f227848
16.6%
c227348
16.6%

Most occurring scripts

ValueCountFrequency (%)
Common2281577
62.5%
Latin1368759
37.5%

Most frequent character per script

ValueCountFrequency (%)
6229236
10.0%
1228583
10.0%
3228249
10.0%
9228192
10.0%
5228173
10.0%
8228109
10.0%
2228085
10.0%
7227968
10.0%
0227741
10.0%
4227241
10.0%
ValueCountFrequency (%)
b228569
16.7%
a228376
16.7%
d228355
16.7%
e228263
16.7%
f227848
16.6%
c227348
16.6%

Most occurring blocks

ValueCountFrequency (%)
ASCII3650336
100.0%

Most frequent character per block

ValueCountFrequency (%)
6229236
 
6.3%
1228583
 
6.3%
b228569
 
6.3%
a228376
 
6.3%
d228355
 
6.3%
e228263
 
6.3%
3228249
 
6.3%
9228192
 
6.3%
5228173
 
6.3%
8228109
 
6.2%
Other values (6)1366231
37.4%

cep_consumidor
Real number (ℝ≥0)

Distinct14844
Distinct (%)13.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean35079.90608
Minimum1003
Maximum99980
Zeros0
Zeros (%)0.0%
Memory size891.3 KiB

Quantile statistics

Minimum1003
5-th percentile3281.6
Q111310
median24320
Q358780
95-th percentile90620
Maximum99980
Range98977
Interquartile range (IQR)47470

Descriptive statistics

Standard deviation29848.80558
Coefficient of variation (CV)0.8508804305
Kurtosis-0.7850673193
Mean35079.90608
Median Absolute Deviation (MAD)16298
Skewness0.7838033662
Sum4001670126
Variance890951194.8
MonotocityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
24220152
 
0.1%
22793147
 
0.1%
22790146
 
0.1%
24230138
 
0.1%
35162123
 
0.1%
22775119
 
0.1%
29101118
 
0.1%
13087108
 
0.1%
36570103
 
0.1%
11740100
 
0.1%
Other values (14834)112819
98.9%
ValueCountFrequency (%)
10031
 
< 0.1%
10042
 
< 0.1%
10056
< 0.1%
10062
 
< 0.1%
10074
< 0.1%
ValueCountFrequency (%)
999803
< 0.1%
999701
 
< 0.1%
999652
< 0.1%
999601
 
< 0.1%
999553
< 0.1%

cidade_consumidor
Categorical

HIGH CARDINALITY

Distinct4073
Distinct (%)3.6%
Missing0
Missing (%)0.0%
Memory size891.3 KiB
sao paulo
18003 
rio de janeiro
 
7873
belo horizonte
 
3160
brasilia
 
2400
curitiba
 
1775
Other values (4068)
80862 

Length

Max length32
Median length9
Mean length10.33448756
Min length3

Characters and Unicode

Total characters1178886
Distinct characters31
Distinct categories5 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique1031 ?
Unique (%)0.9%

Sample

1st rowsao paulo
2nd rowsao paulo
3rd rowsao paulo
4th rowsao paulo
5th rowsao paulo
ValueCountFrequency (%)
sao paulo18003
 
15.8%
rio de janeiro7873
 
6.9%
belo horizonte3160
 
2.8%
brasilia2400
 
2.1%
curitiba1775
 
1.6%
campinas1694
 
1.5%
porto alegre1600
 
1.4%
salvador1445
 
1.3%
guarulhos1351
 
1.2%
sao bernardo do campo1084
 
1.0%
Other values (4063)73688
64.6%
Histogram of lengths of the category
ValueCountFrequency (%)
sao24275
 
12.1%
paulo18084
 
9.0%
de11072
 
5.5%
rio9469
 
4.7%
janeiro7873
 
3.9%
do4921
 
2.5%
belo3232
 
1.6%
horizonte3187
 
1.6%
brasilia2410
 
1.2%
porto1904
 
1.0%
Other values (3256)113541
56.8%

Most occurring characters

ValueCountFrequency (%)
a194510
16.5%
o145414
12.3%
i90118
 
7.6%
r87313
 
7.4%
85895
 
7.3%
e76427
 
6.5%
s72306
 
6.1%
n52274
 
4.4%
u51736
 
4.4%
l51391
 
4.4%
Other values (21)271502
23.0%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter1092452
92.7%
Space Separator85895
 
7.3%
Dash Punctuation280
 
< 0.1%
Other Punctuation257
 
< 0.1%
Decimal Number2
 
< 0.1%

Most frequent character per category

ValueCountFrequency (%)
a194510
17.8%
o145414
13.3%
i90118
 
8.2%
r87313
 
8.0%
e76427
 
7.0%
s72306
 
6.6%
n52274
 
4.8%
u51736
 
4.7%
l51391
 
4.7%
p42919
 
3.9%
Other values (16)228044
20.9%
ValueCountFrequency (%)
11
50.0%
41
50.0%
ValueCountFrequency (%)
85895
100.0%
ValueCountFrequency (%)
-280
100.0%
ValueCountFrequency (%)
'257
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin1092452
92.7%
Common86434
 
7.3%

Most frequent character per script

ValueCountFrequency (%)
a194510
17.8%
o145414
13.3%
i90118
 
8.2%
r87313
 
8.0%
e76427
 
7.0%
s72306
 
6.6%
n52274
 
4.8%
u51736
 
4.7%
l51391
 
4.7%
p42919
 
3.9%
Other values (16)228044
20.9%
ValueCountFrequency (%)
85895
99.4%
-280
 
0.3%
'257
 
0.3%
11
 
< 0.1%
41
 
< 0.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII1178886
100.0%

Most frequent character per block

ValueCountFrequency (%)
a194510
16.5%
o145414
12.3%
i90118
 
7.6%
r87313
 
7.4%
85895
 
7.3%
e76427
 
6.5%
s72306
 
6.1%
n52274
 
4.4%
u51736
 
4.4%
l51391
 
4.4%
Other values (21)271502
23.0%
Distinct27
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size891.3 KiB
SP
48121 
RJ
14739 
MG
13312 
RS
6332 
PR
5816 
Other values (22)
25753 

Length

Max length2
Median length2
Mean length2
Min length2

Characters and Unicode

Total characters228146
Distinct characters17
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowSP
2nd rowSP
3rd rowSP
4th rowSP
5th rowSP
ValueCountFrequency (%)
SP48121
42.2%
RJ14739
 
12.9%
MG13312
 
11.7%
RS6332
 
5.6%
PR5816
 
5.1%
SC4178
 
3.7%
BA3879
 
3.4%
DF2415
 
2.1%
GO2340
 
2.1%
ES2299
 
2.0%
Other values (17)10642
 
9.3%
Histogram of lengths of the category
ValueCountFrequency (%)
sp48121
42.2%
rj14739
 
12.9%
mg13312
 
11.7%
rs6332
 
5.6%
pr5816
 
5.1%
sc4178
 
3.7%
ba3879
 
3.4%
df2415
 
2.1%
go2340
 
2.1%
es2299
 
2.0%
Other values (17)10642
 
9.3%

Most occurring characters

ValueCountFrequency (%)
S62153
27.2%
P58079
25.5%
R27807
12.2%
M16202
 
7.1%
G15652
 
6.9%
J14739
 
6.5%
A6555
 
2.9%
E5988
 
2.6%
C5757
 
2.5%
B4494
 
2.0%
Other values (7)10720
 
4.7%

Most occurring categories

ValueCountFrequency (%)
Uppercase Letter228146
100.0%

Most frequent character per category

ValueCountFrequency (%)
S62153
27.2%
P58079
25.5%
R27807
12.2%
M16202
 
7.1%
G15652
 
6.9%
J14739
 
6.5%
A6555
 
2.9%
E5988
 
2.6%
C5757
 
2.5%
B4494
 
2.0%
Other values (7)10720
 
4.7%

Most occurring scripts

ValueCountFrequency (%)
Latin228146
100.0%

Most frequent character per script

ValueCountFrequency (%)
S62153
27.2%
P58079
25.5%
R27807
12.2%
M16202
 
7.1%
G15652
 
6.9%
J14739
 
6.5%
A6555
 
2.9%
E5988
 
2.6%
C5757
 
2.5%
B4494
 
2.0%
Other values (7)10720
 
4.7%

Most occurring blocks

ValueCountFrequency (%)
ASCII228146
100.0%

Most frequent character per block

ValueCountFrequency (%)
S62153
27.2%
P58079
25.5%
R27807
12.2%
M16202
 
7.1%
G15652
 
6.9%
J14739
 
6.5%
A6555
 
2.9%
E5988
 
2.6%
C5757
 
2.5%
B4494
 
2.0%
Other values (7)10720
 
4.7%

cep_vendedor
Real number (ℝ≥0)

Distinct2136
Distinct (%)1.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean24512.57625
Minimum1001
Maximum99730
Zeros0
Zeros (%)0.0%
Memory size891.3 KiB

Quantile statistics

Minimum1001
5-th percentile2972
Q16429
median13660
Q328470
95-th percentile88344
Maximum99730
Range98729
Interquartile range (IQR)22041

Descriptive statistics

Standard deviation27636.88629
Coefficient of variation (CV)1.127457433
Kurtosis0.9085554207
Mean24512.57625
Median Absolute Deviation (MAD)8130
Skewness1.548794148
Sum2796223110
Variance763797483.7
MonotocityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
149408192
 
7.2%
58492108
 
1.8%
150252092
 
1.8%
90151837
 
1.6%
134051667
 
1.5%
85771545
 
1.4%
47821520
 
1.3%
32041468
 
1.3%
41601249
 
1.1%
132321238
 
1.1%
Other values (2126)91157
79.9%
ValueCountFrequency (%)
100122
 
< 0.1%
102141
 
< 0.1%
10225
 
< 0.1%
10235
 
< 0.1%
1026297
0.3%
ValueCountFrequency (%)
9973012
 
< 0.1%
997002
 
< 0.1%
996701
 
< 0.1%
9950061
0.1%
993002
 
< 0.1%

cidade_vendedor
Categorical

HIGH CARDINALITY

Distinct588
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size891.3 KiB
sao paulo
28427 
ibitinga
8192 
curitiba
 
3067
santo andre
 
3065
sao jose do rio preto
 
2650
Other values (583)
68672 

Length

Max length40
Median length9
Mean length10.10123342
Min length2

Characters and Unicode

Total characters1152278
Distinct characters36
Distinct categories8 ?
Distinct scripts3 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique60 ?
Unique (%)0.1%

Sample

1st rowmaua
2nd rowmaua
3rd rowmaua
4th rowmaua
5th rowmaua
ValueCountFrequency (%)
sao paulo28427
24.9%
ibitinga8192
 
7.2%
curitiba3067
 
2.7%
santo andre3065
 
2.7%
sao jose do rio preto2650
 
2.3%
belo horizonte2535
 
2.2%
rio de janeiro2379
 
2.1%
ribeirao preto2280
 
2.0%
maringa2263
 
2.0%
guarulhos2027
 
1.8%
Other values (578)57188
50.1%
Histogram of lengths of the category
ValueCountFrequency (%)
sao35332
 
18.0%
paulo28705
 
14.6%
ibitinga8192
 
4.2%
rio5711
 
2.9%
do5375
 
2.7%
preto5353
 
2.7%
jose3990
 
2.0%
de3900
 
2.0%
santo3181
 
1.6%
andre3080
 
1.6%
Other values (618)93309
47.6%

Most occurring characters

ValueCountFrequency (%)
a191731
16.6%
o140995
12.2%
i98817
 
8.6%
82115
 
7.1%
r74930
 
6.5%
s73375
 
6.4%
e61820
 
5.4%
u60353
 
5.2%
p56645
 
4.9%
l54779
 
4.8%
Other values (26)256718
22.3%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter1068969
92.8%
Space Separator82115
 
7.1%
Other Punctuation607
 
0.1%
Modifier Symbol366
 
< 0.1%
Dash Punctuation161
 
< 0.1%
Open Punctuation29
 
< 0.1%
Close Punctuation29
 
< 0.1%
Nonspacing Mark2
 
< 0.1%

Most frequent character per category

ValueCountFrequency (%)
a191731
17.9%
o140995
13.2%
i98817
9.2%
r74930
 
7.0%
s73375
 
6.9%
e61820
 
5.8%
u60353
 
5.6%
p56645
 
5.3%
l54779
 
5.1%
t45896
 
4.3%
Other values (14)209628
19.6%
ValueCountFrequency (%)
'343
56.5%
/138
22.7%
.76
 
12.5%
@38
 
6.3%
,6
 
1.0%
\6
 
1.0%
ValueCountFrequency (%)
82115
100.0%
ValueCountFrequency (%)
´366
100.0%
ValueCountFrequency (%)
-161
100.0%
ValueCountFrequency (%)
(29
100.0%
ValueCountFrequency (%)
)29
100.0%
ValueCountFrequency (%)
̃2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin1068969
92.8%
Common83307
 
7.2%
Inherited2
 
< 0.1%

Most frequent character per script

ValueCountFrequency (%)
a191731
17.9%
o140995
13.2%
i98817
9.2%
r74930
 
7.0%
s73375
 
6.9%
e61820
 
5.8%
u60353
 
5.6%
p56645
 
5.3%
l54779
 
5.1%
t45896
 
4.3%
Other values (14)209628
19.6%
ValueCountFrequency (%)
82115
98.6%
´366
 
0.4%
'343
 
0.4%
-161
 
0.2%
/138
 
0.2%
.76
 
0.1%
@38
 
< 0.1%
(29
 
< 0.1%
)29
 
< 0.1%
,6
 
< 0.1%
ValueCountFrequency (%)
̃2
100.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII1151910
> 99.9%
None366
 
< 0.1%
Diacriticals2
 
< 0.1%

Most frequent character per block

ValueCountFrequency (%)
a191731
16.6%
o140995
12.2%
i98817
 
8.6%
82115
 
7.1%
r74930
 
6.5%
s73375
 
6.4%
e61820
 
5.4%
u60353
 
5.2%
p56645
 
4.9%
l54779
 
4.8%
Other values (24)256350
22.3%
ValueCountFrequency (%)
´366
100.0%
ValueCountFrequency (%)
̃2
100.0%

estado_vendedor
Categorical

Distinct22
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size891.3 KiB
SP
81373 
MG
8866 
PR
8812 
RJ
 
4817
SC
 
4174
Other values (17)
 
6031

Length

Max length2
Median length2
Mean length2
Min length2

Characters and Unicode

Total characters228146
Distinct characters16
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowSP
2nd rowSP
3rd rowSP
4th rowSP
5th rowSP
ValueCountFrequency (%)
SP81373
71.3%
MG8866
 
7.8%
PR8812
 
7.7%
RJ4817
 
4.2%
SC4174
 
3.7%
RS2214
 
1.9%
DF921
 
0.8%
BA681
 
0.6%
GO528
 
0.5%
PE462
 
0.4%
Other values (12)1225
 
1.1%
Histogram of lengths of the category
ValueCountFrequency (%)
sp81373
71.3%
mg8866
 
7.8%
pr8812
 
7.7%
rj4817
 
4.2%
sc4174
 
3.7%
rs2214
 
1.9%
df921
 
0.8%
ba681
 
0.6%
go528
 
0.5%
pe462
 
0.4%
Other values (12)1225
 
1.1%

Most occurring characters

ValueCountFrequency (%)
P90706
39.8%
S88202
38.7%
R15913
 
7.0%
M9482
 
4.2%
G9394
 
4.1%
J4817
 
2.1%
C4273
 
1.9%
A1099
 
0.5%
E942
 
0.4%
D921
 
0.4%
Other values (6)2397
 
1.1%

Most occurring categories

ValueCountFrequency (%)
Uppercase Letter228146
100.0%

Most frequent character per category

ValueCountFrequency (%)
P90706
39.8%
S88202
38.7%
R15913
 
7.0%
M9482
 
4.2%
G9394
 
4.1%
J4817
 
2.1%
C4273
 
1.9%
A1099
 
0.5%
E942
 
0.4%
D921
 
0.4%
Other values (6)2397
 
1.1%

Most occurring scripts

ValueCountFrequency (%)
Latin228146
100.0%

Most frequent character per script

ValueCountFrequency (%)
P90706
39.8%
S88202
38.7%
R15913
 
7.0%
M9482
 
4.2%
G9394
 
4.1%
J4817
 
2.1%
C4273
 
1.9%
A1099
 
0.5%
E942
 
0.4%
D921
 
0.4%
Other values (6)2397
 
1.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII228146
100.0%

Most frequent character per block

ValueCountFrequency (%)
P90706
39.8%
S88202
38.7%
R15913
 
7.0%
M9482
 
4.2%
G9394
 
4.1%
J4817
 
2.1%
C4273
 
1.9%
A1099
 
0.5%
E942
 
0.4%
D921
 
0.4%
Other values (6)2397
 
1.1%

Interactions

Correlations

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Missing values

A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.
The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

Sample

First rows

id_pedidoid_consumidorstatus_da_ordemhorario_pedidopedido_aprovadopedido_com_entregadorpedido_entreguedata_estimadaitem_idproduto_idvendedor_iddata_limite_envioprecofretepagamento_sequencialtipo_pagamentoprestacoesvalor_pagamentoid_reviewreview_scoretitulo_reviewcomentario_reviewdata_criacao_reviewdata_resposta_reviewcategoria_produtoqtd_fotos_produtopeso_produtocomprimento_produtoaltura_produtolargura_produtoid_unico_consumidorcep_consumidorcidade_consumidorestado_consumidorcep_vendedorcidade_vendedorestado_vendedor
0e481f51cbdc54678b7cc49136f2d6af79ef432eb6251297304e76186b10a928ddelivered2017-10-02 10:56:332017-10-02 11:07:152017-10-04 19:55:002017-10-10 21:25:132017-10-18 00:00:001.087285b34884572647811a353c7ac498a3504c0cb71d7fa48d967e0e4c94d59d92017-10-06 11:07:1529.998.721.0credit_card1.018.12a54f0611adc9ed256b57ede6b6eb51144NaNNão testei o produto ainda, mas ele veio correto e em boas condições. Apenas a caixa que veio bem amassada e danificada, o que ficará chato, pois se trata de um presente.2017-10-11 00:00:002017-10-12 03:43:48utilidades_domesticas4.0500.019.08.013.07c396fd4830fd04220f754e42b4e5bff3149sao pauloSP9350.0mauaSP
1e481f51cbdc54678b7cc49136f2d6af79ef432eb6251297304e76186b10a928ddelivered2017-10-02 10:56:332017-10-02 11:07:152017-10-04 19:55:002017-10-10 21:25:132017-10-18 00:00:001.087285b34884572647811a353c7ac498a3504c0cb71d7fa48d967e0e4c94d59d92017-10-06 11:07:1529.998.723.0voucher1.02.00a54f0611adc9ed256b57ede6b6eb51144NaNNão testei o produto ainda, mas ele veio correto e em boas condições. Apenas a caixa que veio bem amassada e danificada, o que ficará chato, pois se trata de um presente.2017-10-11 00:00:002017-10-12 03:43:48utilidades_domesticas4.0500.019.08.013.07c396fd4830fd04220f754e42b4e5bff3149sao pauloSP9350.0mauaSP
2e481f51cbdc54678b7cc49136f2d6af79ef432eb6251297304e76186b10a928ddelivered2017-10-02 10:56:332017-10-02 11:07:152017-10-04 19:55:002017-10-10 21:25:132017-10-18 00:00:001.087285b34884572647811a353c7ac498a3504c0cb71d7fa48d967e0e4c94d59d92017-10-06 11:07:1529.998.722.0voucher1.018.59a54f0611adc9ed256b57ede6b6eb51144NaNNão testei o produto ainda, mas ele veio correto e em boas condições. Apenas a caixa que veio bem amassada e danificada, o que ficará chato, pois se trata de um presente.2017-10-11 00:00:002017-10-12 03:43:48utilidades_domesticas4.0500.019.08.013.07c396fd4830fd04220f754e42b4e5bff3149sao pauloSP9350.0mauaSP
3128e10d95713541c87cd1a2e48201934a20e8105f23924cd00833fd87daa0831delivered2017-08-15 18:29:312017-08-15 20:05:162017-08-17 15:28:332017-08-18 14:44:432017-08-28 00:00:001.087285b34884572647811a353c7ac498a3504c0cb71d7fa48d967e0e4c94d59d92017-08-21 20:05:1629.997.781.0credit_card3.037.77b46f1e34512b0f4c74a72398b03ca7884NaNDeveriam embalar melhor o produto. A caixa veio toda amassada e vou dar de presente.2017-08-19 00:00:002017-08-20 15:16:36utilidades_domesticas4.0500.019.08.013.03a51803cc0d012c3b5dc8b7528cb05f73366sao pauloSP9350.0mauaSP
40e7e841ddf8f8f2de2bad69267ecfbcf26c7ac168e1433912a51b924fbd34d34delivered2017-08-02 18:24:472017-08-02 18:43:152017-08-04 17:35:432017-08-07 18:30:012017-08-15 00:00:001.087285b34884572647811a353c7ac498a3504c0cb71d7fa48d967e0e4c94d59d92017-08-08 18:37:3129.997.781.0credit_card1.037.77dc90f19c2806f1abba9e72ad3c3500735NaNSó achei ela pequena pra seis xícaras ,mais é um bom produto\r\n2017-08-08 00:00:002017-08-08 23:26:23utilidades_domesticas4.0500.019.08.013.0ef0996a1a279c26e7ecbd737be23d2352290sao pauloSP9350.0mauaSP
5bfc39df4f36c3693ff3b63fcbea9e90a53904ddbea91e1e92b2b3f1d09a7af86delivered2017-10-23 23:26:462017-10-25 02:14:112017-10-27 16:48:462017-11-07 18:04:592017-11-13 00:00:001.087285b34884572647811a353c7ac498a3504c0cb71d7fa48d967e0e4c94d59d92017-10-31 02:14:1129.9914.101.0boleto1.044.091bafb430e498b939f258b9c9dbdff9b13NaNNaN2017-11-08 00:00:002017-11-10 19:52:38utilidades_domesticas4.0500.019.08.013.0e781fdcc107d13d865fc7698711cc57288032florianopolisSC9350.0mauaSP
68736140c61ea584cb4250074756d8f3bab8844663ae049fda8baf15fc928f47fdelivered2017-08-10 13:35:552017-08-10 13:50:092017-08-11 13:52:352017-08-16 19:03:362017-08-23 00:00:001.0b00a32a0b42fd65efb58a5822009f6293504c0cb71d7fa48d967e0e4c94d59d92017-08-16 13:50:0975.907.791.0credit_card1.083.69b8238c6515192f8129081e17dc57d1695NaNcusto beneficio, simples de usar e rápido2017-08-17 00:00:002017-08-21 12:43:27bebes3.0238.020.010.015.002c9e0c05a817d4562ec0e8c90f29dba8577itaquaquecetubaSP9350.0mauaSP
788407c8c6e12493ff6e845df39540112e902cb9d9992a69a267f69dec57aa3a3delivered2017-08-15 02:03:012017-08-15 02:15:132017-08-16 15:52:292017-08-25 21:59:262017-08-28 00:00:001.0b00a32a0b42fd65efb58a5822009f6293504c0cb71d7fa48d967e0e4c94d59d92017-08-21 02:15:1375.907.791.0credit_card2.083.69186b702b3817fd5cc00b201b11764d634NaNmuitro bom o produto chegou dentro do prazo.2017-08-26 00:00:002017-08-28 20:10:38bebes3.0238.020.010.015.028adbfbaf0b9c5e5a0555a8c853a753413060campinasSP9350.0mauaSP
84f2acff0b7d2bcc4a408abe5a223d407d67b6cca5a87299f711a6961f579fe67delivered2017-08-01 16:31:352017-08-02 02:50:252017-08-03 14:36:342017-08-09 19:56:502017-08-23 00:00:001.0b00a32a0b42fd65efb58a5822009f6293504c0cb71d7fa48d967e0e4c94d59d92017-08-08 02:50:2575.9014.281.0boleto1.090.18567900cb1263f2ee7341989937a789cc5NaNNaN2017-08-10 00:00:002017-08-11 21:08:38bebes3.0238.020.010.015.0aea90564d6f09ae11bf936f55ed49d7282030curitibaPR9350.0mauaSP
9019aaee09698daf81dcffe9d94a18b5ce3893e579755de4feb1a4d0313c103fadelivered2017-08-10 14:04:582017-08-10 14:23:382017-08-11 13:52:352017-08-12 11:56:492017-08-23 00:00:001.0b00a32a0b42fd65efb58a5822009f6293504c0cb71d7fa48d967e0e4c94d59d92017-08-16 14:23:3875.907.791.0credit_card2.083.6943334848a48a7abf6faa2f8aba675b8a2NaNtudo correu bem com a loja e com a entrega mas o produto não funcionou, vou devolver2017-08-13 00:00:002017-08-14 12:24:58bebes3.0238.020.010.015.0cd6b577df45c00daa6b2767eaa947c7213092campinasSP9350.0mauaSP

Last rows

id_pedidoid_consumidorstatus_da_ordemhorario_pedidopedido_aprovadopedido_com_entregadorpedido_entreguedata_estimadaitem_idproduto_idvendedor_iddata_limite_envioprecofretepagamento_sequencialtipo_pagamentoprestacoesvalor_pagamentoid_reviewreview_scoretitulo_reviewcomentario_reviewdata_criacao_reviewdata_resposta_reviewcategoria_produtoqtd_fotos_produtopeso_produtocomprimento_produtoaltura_produtolargura_produtoid_unico_consumidorcep_consumidorcidade_consumidorestado_consumidorcep_vendedorcidade_vendedorestado_vendedor
1140638c1d27c10cc60cc369a428813bb7135018138351c3724e32f1d6e0268f0c7663delivered2018-07-25 16:18:462018-07-25 16:30:202018-07-26 14:31:002018-07-30 19:42:422018-08-13 00:00:001.09680a78df870a1cb6ae00cb3436fe06aa72f15980dc3e9bfd1a49ac9b2f3af652018-07-31 16:30:2089.9018.731.0credit_card1.0108.63f67e51de7cb2234e049746605fac5e454recomendootimo produto2018-07-31 00:00:002018-08-08 04:46:21moveis_decoracao2.0450.016.016.016.0e0333f86b92d8d0de733c3eceed649ce38181araxaMG17512.0mariliaSP
11406439e89b39b5cc8b5e3a38f23e915d18232b91bc260dcffbdacd12c4b09e5c7463delivered2017-07-24 11:29:432017-07-24 11:43:212017-07-24 22:34:382017-08-10 19:42:102017-08-23 00:00:001.024fcd474105d95d2002f38f0cacf87ee72c73be2b085b9d57650dd53eb2004c92017-07-28 11:43:2129.4017.921.0credit_card4.047.32e6de6c25dc2f6e602c1227e20756c9925NaNNaN2017-08-11 00:00:002017-08-16 14:34:55automotivo1.0700.016.07.011.0bd0a735ae91504c00c71638c720e3cca45051vitoria da conquistaBA2116.0sao pauloSP
114065fbff77db5421bb7e1da292db45d07e757795e3faa6e16fc40aafee568b25a85ddelivered2017-03-15 11:41:462017-03-15 11:41:462017-03-16 04:19:032017-03-20 10:34:542017-04-03 00:00:001.0654ccc4e5459e7ba6b8d9fb04c45b9db2d8cfba3fcd3170555941605edaa196a2017-03-21 11:41:4645.0010.961.0credit_card1.08.25c13d0d31c88734e32cd3067bf14d34d75NaNNaN2017-03-21 00:00:002017-03-23 00:59:49livros_tecnicos1.0300.028.02.018.06ee4fdb7edab032aaa8392bab54465469060santo andreSP6080.0osascoSP
114066fbff77db5421bb7e1da292db45d07e757795e3faa6e16fc40aafee568b25a85ddelivered2017-03-15 11:41:462017-03-15 11:41:462017-03-16 04:19:032017-03-20 10:34:542017-04-03 00:00:001.0654ccc4e5459e7ba6b8d9fb04c45b9db2d8cfba3fcd3170555941605edaa196a2017-03-21 11:41:4645.0010.962.0voucher1.047.71c13d0d31c88734e32cd3067bf14d34d75NaNNaN2017-03-21 00:00:002017-03-23 00:59:49livros_tecnicos1.0300.028.02.018.06ee4fdb7edab032aaa8392bab54465469060santo andreSP6080.0osascoSP
1140675bacbd9f42bd029c3a296501224e193e5a1470d43d8ad960d4199134d3df48e0delivered2018-08-10 21:14:352018-08-10 21:25:222018-08-13 13:54:002018-08-21 04:16:312018-08-30 00:00:001.0710e8b076db06c8e5343a9e23f0e3d838dd386be0767c330276ea6a3f96532d32018-08-15 21:25:2244.9922.251.0credit_card2.0134.48f91f12b20162095a387a237e114e7d675NaNNaN2018-08-21 00:00:002018-08-21 22:01:55esporte_lazer2.0600.030.020.020.00b39f417a3c099ff0497346258e8d75239810caraiMG88490.0paulo lopesSC
1140685bacbd9f42bd029c3a296501224e193e5a1470d43d8ad960d4199134d3df48e0delivered2018-08-10 21:14:352018-08-10 21:25:222018-08-13 13:54:002018-08-21 04:16:312018-08-30 00:00:002.0710e8b076db06c8e5343a9e23f0e3d838dd386be0767c330276ea6a3f96532d32018-08-15 21:25:2244.9922.251.0credit_card2.0134.48f91f12b20162095a387a237e114e7d675NaNNaN2018-08-21 00:00:002018-08-21 22:01:55esporte_lazer2.0600.030.020.020.00b39f417a3c099ff0497346258e8d75239810caraiMG88490.0paulo lopesSC
1140691ab38815794efa43d269d62b98dae815a0b67404d84a70ef420a7f99ad6b190adelivered2018-07-01 10:23:102018-07-05 16:17:522018-07-04 14:34:002018-07-09 15:06:572018-07-20 00:00:001.031ec3a565e06de4bdf9d2a511b822b4dbabcc0ab201e4c60188427cae51a5b8b2018-07-10 08:32:3379.0014.131.0boleto1.093.137f9849fcbfdf9fa3070c05b5501bf0665NaNNaN2018-07-10 00:00:002018-07-10 18:32:29construcao_ferramentas_iluminacao2.0750.030.028.028.02077f7ec37df79c62cc24b7b8f30e8c98528ferraz de vasconcelosSP13660.0porto ferreiraSP
114070735dce2d574afe8eb87e80a3d6229c48d531d01affc2c55769f6b9ed410d8d3cdelivered2018-07-24 09:46:272018-07-24 11:24:272018-07-24 15:14:002018-08-02 22:47:352018-08-16 00:00:001.01d187e8e7a30417fda31e85679d96f0fd263fa444c1504a75cbca5cc465f592a2018-07-30 11:24:27399.0045.071.0debit_card1.0444.0719f21ead7ffe5b1b5147a7877c22bae55NaNNaN2018-08-03 00:00:002018-08-04 11:22:40moveis_decoracao2.02100.080.08.030.08cf3c6e1d2c8afaab2eda3fa01d4e3d260455fortalezaCE13478.0americanaSP
11407125d2bfa43663a23586afd12f15b542e79d8c06734fde9823ace11a4b5929b5a7delivered2018-05-22 21:13:212018-05-22 21:35:402018-05-24 12:28:002018-06-12 23:11:292018-06-08 00:00:001.06e1c2008dea1929b9b6c27fa01381e90edf3fabebcc20f7463cc9c53da932ea82018-05-28 21:31:24219.9024.121.0credit_card4.0244.02ec2817e750153dfdd61894780dfc5d9e4NaNNaN2018-06-10 00:00:002018-06-13 09:17:47moveis_decoracao1.05900.041.021.041.0e55e436481078787e32349cee9febf5e39803teofilo otoniMG8320.0sao pauloSP
1140721565f22aa9452ff278638e87cc89567856772dfbcbe7df908a284ff0d53adf7ddelivered2018-05-15 17:41:002018-05-16 03:35:292018-05-16 17:20:002018-05-21 14:31:412018-05-29 00:00:001.09c1e194db1d35a79d962ea610bfe0868f3862c2188522d89860c38a3ea8b550d2018-05-22 03:35:2915.5012.791.0boleto1.028.29cbb879403973e209b4df371a5dafbaa75NaNNaN2018-06-01 00:00:002018-06-01 15:14:23perfumaria1.083.017.08.013.06ceea7c1088e15ab3c67980a2d9bb3099687sao bernardo do campoSP14092.0ribeirao pretoSP